|
I've set up a server backup for my Windows Home Server in the WHS console, but don't see a way to automate the backup to have it run on a scheduled basis in a similar manner to client backups. How can I accomplish this?
I'd like to use the existing server...
Started by arathorn on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at serverfault):
When the server is backed up - All it does is backup up the profile drives and shares to automate the server backups, but following the steps in the following article, you can make it happen (in a nutshell it uses AutoHotKey....
|
|
We are currently considering using Dell's EqualLogic Auto-Snapshot Manager/Microsoft Edition (ASM/ME) to backup our SQL Server databases. However, I am extremely skeptical of this, as ASM/ME uses Microsoft Volume Shadow Copy Service (VSS) to provide a...
Started by Brian Knight on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
Any issues restoring from them as the VSS provider is designed to work with... .
I've used them many times and never had A Guide for SQL Server Backup Application Vendors .
The VSS backup approach is fine for use with SQL Server.
|
|
Is there a nice way to have SQL Server 2005 run nightly backups that are automatically zipped with only the last n backups kept?
I know the agent can perform nightly backups, but I think the tricky part of this question would be the zipping up and removing...
Started by keith on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at serverfault):
After the SQL....
You could use robocopy the resulting files to a safe place .
Here is a review on a SQL Authority.com blog , which also ) from the SQL Server extended stored procedure xp_cmdshell .
Includes the "Schedule Backup, Zip" option.
|
Ask your Facebook Friends
|
In order to take regular backups, we want to compress and upload files from our Windows Server to Amazon S3 service. Is there any freeware application that allows us to schedule regular backups?
Started by Gopinath on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Post describes how to automate SQL Server backups with PowerShell to Amazon S3:
Randoom: EC2 SQL Server backup strategies and tactics I found a nice command prompt application to automate the backups CloudBerry ....
|
|
There is a lot of software out there that backs up SQL Server directly out of the database, rather than backing up a file which was pulled out of SQL Server. I have always been fearful of using it, in terms of its impact on the production system. Does...
Started by Yishai on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at serverfault):
You can create a batch script that backs up your database database in file using a batch script * replication of production databases to backup server - failure native backup ....
SQL Server backups are enterprise grade.
|
|
I don't see any built in mechanism for scheduling nightly backups in SQL Server 2005. What tools are available to perform this task and how reliable are they?
Started by cowgod on
, 8 posts
by 8 people.
Answer Snippets (Read the full thread at serverfault):
Network backup is....
We link to some good backup scripts off that video.
That'll give you more flexibility and power.
The necessary backup jobs (SQL Server 2005 Books Online: How to: Create a Maintenance Plan backups.
|
|
What are the recommendations of software products for creating automated backups of SQL Server 2008 databases?
The backup should happen without taking the database offline/detatching.
Started by blu on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
In this case be configured....
I would recommend just creating a maintenance plan in SQL Server to handle the backups, it can/library/ms189715.aspx
If you are using SQL Server Express , you wont find a UI to run periodic backups.
|
|
Good evenening!
I'm searching for an easy way of storing incremental backups of a linux server on a remote windows home server. Both machines have their own static IP address. The linux machine is a Ubuntu virtual server machine, which should save its...
Started by Thasmo on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at serverfault):
Rdiff-backup is available, but it's a full-featured backup system, and it will do incremental backups, compression, and even in the main ubuntu....
Rdiff-backup naturally does incremental backups.
See rdiff-backup .
|
|
I have created scheduled backup and shrink maintenance plans for my SQL 2005 instances using the tools in SQL Server Management Studio.
I am wondering, is there an equally easy method for compressing the backups once they have been created?
Started by blueberryfields on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at serverfault):
Check out SQL Toolbelt to integrate and use, you ... .
There are third-party tools out there that allow you to compress your backups.
So with SQL 2005 you need to look.
Native Backup Compression wasn't added until SQL Server 2008.
|
|
I am looking to automate the encryption of my backups, and SQL Server 2005 does not appear to include built in functionality to do the work. Similar to the question here - http://serverfault.com/questions/72689/is-it-possible-to-configure-sql-server-2...
Started by blueberryfields on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at serverfault):
Encryption and compression don't SQL Backup from Red Gate....
Questions/72689/is-it-possible-to-configure-sql-server-2005-to-auto-compress-backups
A lot of those answers encrypt backups, but you can encrypt them using third party tools.
|
