September 15, 2009 at 2:35 pm
Has anyone tried this? Reads a folder containing bak, dif and trn backups and generates restore commands. Also handles multiple file groups and the "WITH MOVE" needed in the restore statements when going onto a new server with different drives.
http://www.pythian.com/news/1515/easier-sql-server-database-restores
But it doesn't seem to do anything with the differential backups.
September 21, 2009 at 8:06 am
Indianrock (9/15/2009)
Has anyone tried this? Reads a folder containing bak, dif and trn backups and generates restore commands. Also handles multiple file groups and the "WITH MOVE" needed in the restore statements when going onto a new server with different drives.http://www.pythian.com/news/1515/easier-sql-server-database-restores
But it doesn't seem to do anything with the differential backups.
had a quick look at the script, I have noticed that someone has commented that the diff's dont work.
It isnt something I would use, I prefer to do restores/backups the old fashioned way, and If I needed a script to do it for me, I would write my own.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 21, 2009 at 8:28 am
I was looking for some "automated" help when, in a disaster, you need to restore a full backup, most recent diff and dozens of incremental ( tlog ) backups to a different server where management studio doesn't display all needed files for you. Tried log shipping for a long time but have dropped it for reasons I won't go into here.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply