December 8, 2010 at 3:01 am
which one is faster is restore or attaching a db...and which one is best while doing the migration of db's from one server to another server and what are the suitable codition to go for backup/restore and dettach/attach
December 8, 2010 at 3:13 am
There has been much discussion on this in the past, some of it rather partisan. Please search for attaching versus restoring, have a read, and then post back if there's still anything you don't understand.
John
December 8, 2010 at 5:09 am
When you use the detach/attach method, you'll have to detach you source
database which means that at that point you haven't even got your source
in a safe condition any longer.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 8, 2010 at 5:59 am
Attach is faster. But that really doesn't cover the question. The real question is what are you doing? Are you moving a database from one server to another? Then detach/attach might be a good choice. Are you creating a disaster recovery scenario? Then detach/attach is a serious waste of time and you need to get backups in place. To really provide you with the information you need, you need to say what you're looking to do.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 8, 2010 at 6:07 am
- another thing to keep in mind is the size of your database files vs the size of your backup file(s). (time needed for the copy/move action)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
December 11, 2010 at 5:16 pm
Follow Grant's advice. He is right there.
Thank You,
Best Regards,
SQLBuddy
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply