Verifying the restore

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 716226

    Comments posted to this topic are about the item Verifying the restore

  • Stewart "Arturius" Campbell

    SSC Guru

    Points: 71444

    Interesting question, thanks Steve
    Learned something, which is a great way to end the week

    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

  • Shayn Thomas


    Points: 5422

    Didn't know about the checking for available space so learned something new,

    Cheers Steve

    The more you know, the more you know that you dont know

  • Grant Fritchey

    SSC Guru

    Points: 395585

    Heck, I didn't know it checked for available space.

    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
    Theodore Roosevelt

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

  • Thomas Franz

    Hall of Fame

    Points: 3565

    The whole, valid command would be (plus maybe some with-options)
    RESTORE VERIFYONLY FROM DISK='\\SERVER1\Backup\my_big_db\FULL\SERVER1_my_big_db_FULL_20180803_210600.bak'

    Sorry, but checking the disk space does not make any sense, since I do not specify, where I want to restore the database. It could be my local 128-GB SSD which would be never sufficient for a 500 GB database or it could be the 3 TB SAN drive. I could drop or overwrite the old database before executing the restore. I could increase the SAN-drive or could delete some old stuff...

    God is real, unless declared integer.

  • Scott Coleman

    One Orange Chip

    Points: 27402

    The restore location is the original file locations, or you can use RESTORE VERIFYONLY ... WITH MOVE to specify somewhere else.  Either way, the restore location is always defined.

  • HappyGeek


    Points: 18666

    Grant Fritchey - Friday, August 3, 2018 5:31 AM

    Heck, I didn't know it checked for available space.

    New one on me too, thanks Steve.


Viewing 7 posts - 1 through 7 (of 7 total)

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