Restore script 'N' - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Restore script 'N'

Author

Topic

pdset
Constraint Violating Yak Guru

310 Posts

Posted - 2014-05-18 : 20:38:55

I have procured this RESTORE script.

In which what stands for 'N'

RESTORE DATABASE [DATABASENAME]
FROM DISK = N'E:\Backups\DATABASENAME.bak'
WITH FILE = 1, MOVE N'DATABASENAME_Data' TO N'C:\DATABASENAME.mdf',
MOVE N'DATABASENAME_Log' TO N'C:\DATABASENAME.LDF', NOUNLOAD, REPLACE, STATS = 10
GON'

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2014-05-18 : 21:39:58

unicode string

KH
[spoiler]Time is always against us[/spoiler]