SQL SERVER 2005 backups (what is meaning of =N )

Question

SQL SERVER 2005 backups (what is meaning of =N )

ganeshanmsc

SSC Veteran

Points: 226
More actions
July 8, 2010 at 3:59 pm

#223070

ok i have one dpubt in sqlserver 2005
u will take full backup (or) any one backups
under the code like =N
BACKUP DATABASE [test] TO DISK = N'E:\Backup2005\test.bak'
what is meaning of =N

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

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

Nils Gustav Stråbø SSChampion Points: 11259 More actions · Answer 1

N means that it is a unicode string. I'm not sure if this parameter in BACKUP DATABASE is unicode or not. BOL doesn't say.

Tara Kizer SSCommitted Points: 1789 More actions · Answer 2

Adding N only matters if you are going to have a unicode character in the string, such as a Chinese character. For the example you posted, you can safely remove the N.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
Ramblings of a DBA (My SQL Server Blog)[/url]
Subscribe to my blog