Tuesday, January 06, 2009 Register   Login   
   You Are Here: Discussions      
 SQL Community Portal
  
 Recently Submitted Articles
  
 Recent SQL Clinic Articles
  
 SQL Server Discussion Forums
 
  SQL Server Forums  Discussions  SQL Server DBA ...  scripts - automated dump/load
Previous Previous
 
Next Next
New Post 2/9/2008 4:45 AM
Resolved
User is offline s sasi
1 posts
No Ranking


scripts - automated dump/load  
Hi

I have a sql 2005 application which requires the nightly db backups to be copied across to its test server and refreshed.

Does anyone know of any useful scripts that might be able to do this? It will need to work out the latest backup files on the prod server msdb..backuphistory, xcopy these to the test server and refresh these databases and also fix users etc.

Thanks
 
New Post 2/12/2008 7:33 AM
User is offline Brian Kelley
1 posts
No Ranking


Re: scripts - automated dump/load  
It may be easier to attack identifying and copying the backup files using an operating system script such as with VBScript or Powershell. Technically you can look for files newer than a certain date in the directories you specify, copy them to the proper location, and then make a database connection to restore the databases and synch the users.
 
New Post 2/29/2008 3:56 PM
User is offline Cindy Gross
16 posts
No Ranking


Re: scripts - automated dump/load  
There are various manual log shipping scripts floating around on the internet. You could probably adapt one of those (true log shipping leaves the db unrecovered so you couldn't use them unmodified).
 
Previous Previous
 
Next Next
  SQL Server Forums  Discussions  SQL Server DBA ...  scripts - automated dump/load

  
   Minimize

  
SQL Server 2000 Downloads
 
SQL Server 2000 Reporting Services Downloads
 
SQL Server 2000 Notification Services SP Downloads
 
SQL Server CE Downloads
 
SQLXML 3.0 Service Pack Downloads
 
SQL Server 2000 JDBC Driver
 
MDAC 2.6 Download
 
SQL Server 2000 Tools Downloads
SQL Server 2005 & SQL Server 2000 Best Practices
·    DMV Stats
 
·    Buffer Cache
·    Input/Output
·    Performance
·    Tempdb
·