June 5, 2008 at 2:02 pm
hi
I need to refresh the databases from one instance of the production box to testing server.
What is the process for to do it?
June 5, 2008 at 2:17 pm
Backup the production database and restore it to your test instance.
😎
June 5, 2008 at 2:37 pm
You can also create a Maintenance Task that will do it all for you, then you can schedule it to fire off when ever you need. You could even write it all in one stored procedure.
Write once, use many.
Andrew SQLDBA
June 5, 2008 at 10:07 pm
[font="Verdana"]If you are in SQL2005 then you can try copy database wizard. Check the link http://msdn.microsoft.com/en-us/library/ms188664.aspx for the same!
This is a one time process or need to do daily??[/font]
Regards..Vidhya Sagar
SQL-Articles
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply