February 2, 2012 at 2:42 pm
The advantage of Backup/Restore is it will automatically include any new tables that get added to the database in the future.
If it's going to a different server then you may have to consider orphaned users.
February 2, 2012 at 3:12 pm
homebrew01 (2/2/2012)
The advantage of Backup/Restore is it will automatically include any new tables that get added to the database in the future.If it's going to a different server then you may have to consider orphaned users.
So would the mirror/snapshot.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 2, 2012 at 11:18 pm
Evil Kraig F (2/2/2012)
homebrew01 (2/2/2012)
The advantage of Backup/Restore is it will automatically include any new tables that get added to the database in the future.If it's going to a different server then you may have to consider orphaned users.
So would the mirror/snapshot.
Even log shipping would be a better idea than SSIS...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply