1
kudos
spam Kudos Remove

SQL SERVER – Fastest Way to Restore the Database « Journey to SQL Authority with Pinal Dave

published 705 days, 10 hours, 19 minutes ago posted by pinaldavepinaldave 714 days, 18 hours, 40 minutes ago
Friday, June 18, 2010 12:11:40 PM GMT Wednesday, June 09, 2010 3:51:09 AM GMT

A few days ago, I received following email: “Pinal, We are in an emergency situation. We have a large database of around 80+ GB and its backup is of 50+ GB in size. We need to restore this database ASAP and use it; however, restoring the database takes forever. Do you think a compressed backup would solve our problem? Any other ideas you got?” First of all, the asker has already answered his own question. Yes; I have seen that if you are using a compressed backup, it takes lesser time when you try to ...

category: Query | clicked: 1 | | source: blog.sqlauthority.com | show counter code
tags: pinaldave, SQL, SQLAuthority, SQLServer

No comments yet, be the first one to post comment.

To post your comment please login or signup