|
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.
|
|
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.
|
Ask your Facebook Friends
|
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.
|
|
What is the best free way to get your maintenance plan-generated backups compressed?
I know there are non-free tools that will compress the backups, but I'm not interested in them.
Options:
Have a T-SQL task after the backups that will run a script through...
Started by Vinko Vrsalovic on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
Also, I believe SQL2008 (at least some flavours) will do compressed... .
Compressing SQL Server backup filesI'd schedule a task after the backup to do it as you already suggest.
Cobian then zips the result and saves it to a destination .
|
|
I need some help for executing my planned backup strategy.
My database is about 1 gig in size. I want to perform a full backup once per week, and incremental every hour.
Is all of this built into SQL Server 2005 Express?
Is it possible to roll over the...
Started by AnonymousAnonymous on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
The other issue is you won't have the SQL ServerSQL Server express does not have the ability to setup maintenance plans, therefore you must.
You will want to script the backup yourself.
They solve.
|
|
I am running a small network (5 clients) on a server running SBS2k3. I'd like to be able to set up a NAS in a remote location in order to schedule nightly, incremental backups on the server drives. I'd also like to run a full backup once a week. Can anyone...
Started by Mike C on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at serverfault):
I've gotHave a look at BackupExec....
Server 2008 backup works fine to it, but you could use something like BackupExec or Cobian.
It serves my needs.
Mostly I use Acronis Backup & Recovery 10 Advanced Server SBS Edition.
|
