none
Restoration of database

    Question

  • I used the script below to restore a database to a different server.

    RESTORE DATABASE [DbAndDirList] FROM  DISK = N'D:\backupdir\DbAndDirList.bak' WITH  FILE = 1,  NORECOVERY,  NOUNLOAD,  STATS = 10
    GO
    RESTORE LOG [DbAndDirList] FROM  DISK = N'D:\backupdir\DbAndDirList.trn' WITH  FILE = 1,  NORECOVERY,  NOUNLOAD,  STATS = 10
    GO
    RESTORE LOG [DbAndDirList] FROM  DISK = N'D:\backupdir\DbAndDirList1.trn' WITH  FILE = 1,  NOUNLOAD,  STATS = 10
    GO

    What exactly the 'NOUNLOAD' & 'STATS = 10' means? Anybody could please explain?

     

    Tuesday, October 22, 2013 11:28 AM

Answers

  • What exactly the 'NOUNLOAD' & 'STATS = 10' means? Anybody could please explain?

    See RESTORE (Transact-SQL)

    NOUNLOAD is only for tape drives, = "Specifies that the tape is automatically rewound and unloaded when the backup is finished. UNLOAD is the default when a session begins."

    Stats = 10 means, SQL Server reports the restore progress for each 10% step.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]


    Tuesday, October 22, 2013 11:36 AM