scritp to automate restore - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

scritp to automate restore

Author

Topic

thirulok.thilagar
Starting Member

1 Post

Posted - 2011-03-23 : 14:27:09

HI
I WANT A SCRIPT WHICH WILL AUTOMATE RESTORES.
WE HAVE 3 PROD SERVERS(200 DBS ON EACH SERVER), AND WE WANT TO EVALUATE THE BACKUPS TAKEN IN THE PROD SERVERS.OUR PLAN NOW IS TO TAKE RANDOM BACKUPS IN EACH SERVER AND RESTORE THEM IN A TEST BOX.THESE RANDOM BACKUPS ARE BEING DUMPED INTO ONE COMMON LOCATION AND THIS IS USED AS THE BACKUP REPOSITORY.

CAN YOU GUYS PLEASE HELP ME WITH THIS SCRIPT

THANKS IN ADVANCE

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-03-23 : 14:50:34

This should help you: http://weblogs.sqlteam.com/tarad/archive/2009/02/25/How-to-refresh-a-SQL-Server-database-automatically.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Yeoh Ray Mond
Starting Member

49 Posts

Posted - 2011-03-24 : 20:24:04

Not a script, but a tool that may help - SQL Verify.

Ray Mond

RESTORE VERIFYONLY - don't bet your job on it! Learn why here.
TLogInfo - the only FREE tool to analyse your transaction logs. Download here..
SQLBakReader - the only FREE tool to inspect your SQL Server backup files without using SQL Server. Download here..

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources