tag:blogger.com,1999:blog-7367794905551891931.post5962463016968297390..comments2011-12-27T09:10:32.637-05:00Boyan Kostadinovhttps://profiles.google.com/106560991906301776392noreply@blogger.comBlogger15125tag:blogger.com,1999:blog-7367794905551891931.post-77244258757308696122011-11-01T13:51:33.593-04:002011-11-01T13:51:33.593-04:00Brilliant!!<br /><br />Thank you for posting this.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7367794905551891931.post-23226856944926300542010-05-11T09:41:17.808-04:002010-05-11T09:41:17.808-04:00Brilliant Stuff, thanks a million.FarmBoyhttp://www.blogger.com/profile/02268018884107282487noreply@blogger.comtag:blogger.com,1999:blog-7367794905551891931.post-71011257315948564172009-11-05T14:35:54.482-05:002009-11-05T14:35:54.482-05:00I haven&#39;t worked with Red Gate backups so I don&#39;t know.Boyan Kostadinovhttp://www.blogger.com/profile/01361725622852028759noreply@blogger.comtag:blogger.com,1999:blog-7367794905551891931.post-61720935743663860272009-10-28T09:36:59.825-04:002009-10-28T09:36:59.825-04:00Thank you so much for posting this. But had a quick question. In my scenario i have four different backup files created by red gate backups. How can I assign these files to the restore script. Any ideas would be appreciated.shalalahttp://www.blogger.com/profile/09981809453720779967noreply@blogger.comtag:blogger.com,1999:blog-7367794905551891931.post-23147948214192044542009-05-14T18:20:00.000-04:002009-05-14T18:20:00.000-04:00Awesome - I was able to modify it very easily to fit our environment! Thanks a bunch.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7367794905551891931.post-25405058452140761932009-02-23T07:55:00.000-05:002009-02-23T07:55:00.000-05:00thanks a LOT for such a wonderful script !!Vikram Saxenahttp://www.blogger.com/profile/15552913978818784617noreply@blogger.comtag:blogger.com,1999:blog-7367794905551891931.post-91270987875632012402008-12-18T15:57:00.000-05:002008-12-18T15:57:00.000-05:00I added a variable for the original DB name so it would get the right file name to restore. Your script works great, thanks for sharing.Doughttp://www.blogger.com/profile/17705636570525092399noreply@blogger.comtag:blogger.com,1999:blog-7367794905551891931.post-71946374348534709722008-12-18T12:07:00.000-05:002008-12-18T12:07:00.000-05:00Doug, the script would work in your scenario assuming that you specify the name of the database to restore as and that database already exists.Boyan Kostadinovhttp://www.blogger.com/profile/01361725622852028759noreply@blogger.comtag:blogger.com,1999:blog-7367794905551891931.post-75221842453453390952008-12-18T11:47:00.000-05:002008-12-18T11:47:00.000-05:00I backup a DB and restore to the same server but with a different DB name. For instance, I back "pro" and restore to "ptest". Will this script work in this scenario or will it need to be tweaked?Doughttp://www.blogger.com/profile/17705636570525092399noreply@blogger.comtag:blogger.com,1999:blog-7367794905551891931.post-5968776117855233932008-11-06T14:54:00.000-05:002008-11-06T14:54:00.000-05:00AWSOME POST! I am somtimes restoring my development environment sometime 3 to 4 times a week.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7367794905551891931.post-48270594913691803812008-10-02T14:46:00.000-04:002008-10-02T14:46:00.000-04:00Thank you for saying so. It's people's appreciation that make all this worth posting. Which reminds me, I should start writing again :-)Boyan Kostadinovhttp://www.blogger.com/profile/01361725622852028759noreply@blogger.comtag:blogger.com,1999:blog-7367794905551891931.post-13009940048004156682008-10-02T14:05:00.000-04:002008-10-02T14:05:00.000-04:00You have NO idea how long I have been trying to find out to backup and restore -- to make it easy and foolproof.<BR/><BR/>But you just made my day.<BR/><BR/>Thank you for sharing your expertise. You could have just gone on your way and used your "Aha!" moment for your own use. You chose to give others a lift. Thank you VERY much!<BR/><BR/>I'll think of you every time I back up and restore!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7367794905551891931.post-84465104708764996042008-07-08T14:09:00.000-04:002008-07-08T14:09:00.000-04:00It's people appreciation what makes it worth doing, so thank you.Boyan Kostadinovhttp://www.blogger.com/profile/01361725622852028759noreply@blogger.comtag:blogger.com,1999:blog-7367794905551891931.post-6365813687425129232008-07-08T13:43:00.000-04:002008-07-08T13:43:00.000-04:00It is gems like this that make the blogosphere so important. Thank you for taking the time to put your hard work online.Shanehttp://www.blogger.com/profile/11131095267284458684noreply@blogger.comtag:blogger.com,1999:blog-7367794905551891931.post-15371731231405163902008-02-15T06:29:00.000-05:002008-02-15T06:29:00.000-05:00Great workAnonymousnoreply@blogger.com