December 29, 2009 at 9:45 pm
kareem007 (12/29/2009)
Thanks Medishetty!
You are welcome !
I tried with normal Restore with backup (overrite existing db)...that worked for me. In what way detach/attach better than restore backup.
A detach/ attach does not need time when compared to restoring as you must have seen today attaching any size of database is done in no time. Also attach/detach does not need additional storage space as backup requires. The -ve point in detach/attach is that it requires the DB to be offline.
After doing detach and attach. If I want to use primary server for any reporting, do I need to install SSRS again?
If you have not uninstalled the SQL Server Reporting Services using Add/Remove Programs, then you are still good with the previous installation, if you have not attached back (the original DB's at Primary Server) attach them and you can continue using it.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 30, 2009 at 7:25 am
Just adding a note to your original question and the excellent answer already provided.
Not only can you restore up the chain in terms of versions, but you can restore up the chain in terms of service packs. Conversely, if you try to restore a database with a newer server pack onto a server with an older service pack, you may run into problems.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply