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.
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 |
|
|
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 MondRESTORE 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.. |
|
|
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/ |
|
|
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) |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|