01-04-2012 12:50 PM
Is it possible to restore an old SQL 2005 DB without stopping or overwriting the current production DB. I have a backup of a DB from last month that I need to be able to access. Can I restore it to another drive while leaving the production instance online? All the blogs and post I've seen so far will show you how to do everything but that :( Oh and another catch, the drive is about 80% full so it has to be restored to a different drive.
Thanks
Solved! Go to Solution.
01-04-2012 01:24 PM
Have you looked at https://www-secure.symantec.com/connect/forums/how-safely-retore-sql-database ?
01-04-2012 01:24 PM
Have you looked at https://www-secure.symantec.com/connect/forums/how-safely-retore-sql-database ?
01-04-2012 02:15 PM
Thank you that's just what I needed. I'm @ 58% already. I'll use resplana's response
Thank you! I'm confident now to restore database w/o doing any mess :) thanks