October 22, 2007 at 4:10 am
Hi all
Every day Iam getting full backup,I have Restore the Database in Database.
can make restoration Proccess as a automated,what is best way to follow,What are the Admin Over heads.
Please help me ragarding on this issue.
Thanks in Advance
October 22, 2007 at 1:17 pm
Hi,
Your question is a little unclear. Are you asking whether you should restore your full backup as a different database once the backup has completed? If so, yes, that's a very good practice to make sure the backup is valid. If not, can you try expressing your question again?
Thanks
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
October 23, 2007 at 2:27 am
Well what I understand is that he is taking daily backups of the primary database server and restoring it on the backup database server, which is supposed to upgraded to primary server, in the case if the original database or database server gets corrupted or down.
Khurram.
October 23, 2007 at 2:49 am
Hi all,
Well, from what I gather, I think what he's trying to say/achieve is whether or not to use automated database restoration on a daily basis. I suppose it is an intelligent solution, to an extent though. If you opt for this solution, there are possibilities that database integrity may be compromised should there be a system failure or anything to that extent. If you encounter problems during your automated backup restoration solution, it is imperative that the necessary steps be taken to eliminate errors and verify the integrity of your data before proceeding to use the database. It all depends on the type of data you're dealing with and how important it is to the organization.
Khulani
DCS Consulting
October 23, 2007 at 3:23 am
It depends on the functionality/business process on how we do the data restoration. Better, u create jobs by invoking connections, pointing to the particular databases, set the time and run through the wizard. Sometimes, this may fail so as to ensure that the SQL AGENT is up & running and kindly check your services for the same is always in RUN mode.
October 23, 2007 at 9:21 pm
Automated restores work fine, just be sure you're restoring to the right server!
You need to remove all connections as well from the test server, so you might set up a job with multiple steps to do this, do the restore, etc.
I'd also copy the backup file from the source and give it the same name everyday. Makes restoring much simpler.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply