July 23, 2018 at 11:27 pm
Comments posted to this topic are about the item Restoring without CHECKSUM
July 23, 2018 at 11:28 pm
Nice question, thanks Steve.
Particularly enjoyed some of the wrong answer
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
July 24, 2018 at 12:51 am
Good question, thanks Steve.
...
July 24, 2018 at 4:02 am
Steve Jones - SSC Editor - Monday, July 23, 2018 11:27 PMComments posted to this topic are about the item Restoring without CHECKSUM
Pls, note that "RESTORE DATABASE" needs the database name.RESTORE DATABASE [?????] FROM DISK = 'auditdata.bak' WITH REPLACE;
July 24, 2018 at 7:20 am
Carlo Romagnano - Tuesday, July 24, 2018 4:02 AMPls, note that "RESTORE DATABASE" needs the database name.
RESTORE DATABASE [?????] FROM DISK = 'auditdata.bak' WITH REPLACE;
Good catch. I'll get that fixed.
"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
July 24, 2018 at 9:08 am
Nice question,
I got it wrong as not done much with CHECKSUM so will give me something to read up on
Ta
---------------------------------------------------------------------------------------
The more you know, the more you know that you dont know
July 26, 2018 at 6:12 pm
Nice question. Thanks.
August 10, 2018 at 7:07 am
This restore needs to be run from master or from other DB. If someone is already there in that DB and trying to restore will throw an error msg. But just a precaution before running this command. Nice question, Steve.
Thanks.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply