February 27, 2010 at 1:54 pm
I have a setup a test server using Production server.
I have over 100 jobs and SSIS packages in Production server.
I have get to everything into test server without shutting down production server. Like I want to setup test server with 1 day old data from prod server.
Can someone help me with this and give detailed steps to do.
Thanks in Advance.
February 27, 2010 at 3:03 pm
To transer the jobs/ssis you can use SSIS itself to copy the jobs.
With regards to the data there are a number of option..
I would go with automated backup/restore as there is no impact on the live server when restoring the db.
February 27, 2010 at 3:24 pm
I'm new to SQL so if you dont mind can you send me step by step instructions.
February 27, 2010 at 4:23 pm
If you are going to use the restore database option, then here is an article on doing that
http://msdn.microsoft.com/en-us/library/ms177429.aspx
Another option is to purchase sql compare and sql data compare from redgate. That will allow you to compare schemas and data and move the data and schema from prod down to dev.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 27, 2010 at 5:13 pm
restore option will restore data. How about moving jobs and ssis packages?
February 27, 2010 at 5:16 pm
Sri - SQL (2/27/2010)
restore option will restore data. How about moving jobs and ssis packages?
Restore the msdb database is an option to move the jobs.
Data compare will help transfer that info too.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply