Sql Backup And FTP

Welcome Guest Search | Active Topics | Log In | Register
New Topic Post Reply
Automating restore backups Options · View
Guest
#1 Posted : Thursday, August 13, 2009 1:32:17 AM Quote
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 732
I really wish your product would automate restoring backups
ruslan
#2 Posted : Thursday, August 13, 2009 1:33:18 AM Quote
Rank: Administration

Groups: Administrators

Joined: 8/10/2009
Posts: 368
While we've tried making backups as easy as possible, we do not think that restoring them should be one-click operation due to implications that incorrect restore could cause. Having full backups makes the task easy for anyone with minimal SQL knowledge. We think the person who will take responsibility for restoring backups should at least know RESTORE DATABASE command or be aware of Restore option in SQL Management studio

Guest
#3 Posted : Saturday, August 14, 2010 9:30:04 AM Quote
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 732
I would like the option of using the program to restore the backup automatically to another SQL database, which we use as a testing database. Currently I have to unzip the backup and then restore the backup manually. If there was an option to save the backup to a known filename and not in a compressed format I could implement this using the existing After Backup SQL custom script option. Thanks :)
mikeshilov
#4 Posted : Monday, August 16, 2010 5:17:10 AM Quote
Rank: Administration

Groups: Administrators

Joined: 8/12/2009
Posts: 271
At the moment we're implimenting some features which will allow users to choose a file name format (including constant name) and to disable zipping if necessary. I hope the new version will be released very soon.

Best Regards,
Mike
ruslan
#5 Posted : Wednesday, September 01, 2010 2:27:48 PM Quote
Rank: Administration

Groups: Administrators

Joined: 8/10/2009
Posts: 368
Guest wrote:
I would like the option of using the program to restore the backup automatically to another SQL database, which we use as a testing database. Currently I have to unzip the backup and then restore the backup manually. If there was an option to save the backup to a known filename and not in a compressed format I could implement this using the existing After Backup SQL custom script option. Thanks :)

Yes, with the current version you can save if in a fixed format and without compression. Then just run RESTORE DATABASE.
Quick Reply Show Quick Reply
New Topic Post Reply
Forum Jump  
You can post new topics in this forum.
You can reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You can create polls in this forum.
You can vote in polls in this forum.