Post reply

Backup/Restore T-SQL

  • October 28, 2011 at 4:03 am

    #390711

    Hi Guys

    When scripting to new query window a Restore database job

    RESTORE DATABASE [DB] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup\DB.bak' WITH FILE = 8, NORECOVERY, NOUNLOAD, STATS = 10

    What does the "N" and the "STATS = 10" indicate?

    Thanks

    Derek

  • October 28, 2011 at 4:11 am

    #1400544

    The N is not specific to restores, it is the way of telling sql server that the string value could be unicode.

    The stats is a percentage showing how often you want the restore monitor to report it status.

  • October 28, 2011 at 4:20 am

    #1400546

    steveb. (10/28/2011)

    The N is not specific to restores, it is the way of telling sql server that the string value could be unicode.

    The stats is a percentage showing how often you want the restore monitor to report it status.

    Cool - Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

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