Quick question on restore database

  • 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.


    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • 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 Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply