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
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Automating database restore

Author  Topic 

Hetty

1 Post

Posted - 2011-03-04 : 22:37:34
I need help urgently.

Can anyone explain to me how to automate restore from production to development database for testing purposes?

Your quick response will be greatly appreciated.

Thanks,
Hetty

Sachin.Nand

2937 Posts

Posted - 2011-03-04 : 23:42:47
What should be the interval by which you can want to restore the DB ?You can create a maintenance plan that takes backup from production and restores to test DB or you can create a SSIS task.

PBUH

Go to Top of Page

Yeoh Ray Mond
Starting Member

49 Posts

Posted - 2011-03-06 : 04:24:52
If you're restoring a lot of databases, and you don't want to have to create multiple maintenance plans/SSIS tasks, take a look at 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..
Go to Top of Page

pk_bohra
Master Smack Fu Yak Hacker

1182 Posts

Posted - 2011-03-06 : 05:13:47
Have a look at :
http://www.sqlservercentral.com/articles/Backup+%2F+Restore/71272/
Go to Top of Page

Bustaz Kool
Master Smack Fu Yak Hacker

1834 Posts

Posted - 2011-03-07 : 19:36:38
Would Snapshot Replication be of use in your environment? You could schedule it to run on a regular (daily?) basis or on demand.

=======================================
Elitism is the slur directed at merit by mediocrity. -Sydney J. Harris, journalist (1917-1986)
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-03-07 : 19:51:24
I have an article on this very topic: 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
Go to Top of Page
   

- Advertisement -