TSQL Backup Syntax

17 Jan 2005 4:05 PM

Michael

Hi,

I was just wondering could someone tell me what the
TO DISK = N part of the statement below is doing ?

TO DISK = N'C:\Test SQL Backups\Diff Backups\Northwind\NorthwindDiff1200.bak'

Thanks

17 Jan 2005 4:20 PM

Keith Kratochvil

N stands for unicode. You don't really need it.
The stuff within quotes refers to the directory and file name where the
backup file will be created.

--
Keith

"Michael" <Mich***@discussions.microsoft.com> wrote in message
news:CA5C0B7A-7C12-4F17-A951-3B2F98D5DD13@microsoft.com...
> Hi,
>
> I was just wondering could someone tell me what the
> TO DISK = N part of the statement below is doing ?
>
> TO DISK = N'C:\Test SQL Backups\Diff

Backups\Northwind\NorthwindDiff1200.bak'
Show quote

>
> Thanks
>
>

17 Jan 2005 4:23 PM

Andrew J. Kelly

The N indicates the string is of the unicode type. The DISK = N'xxx' tells
sqls erver where the physical backup file will be located and what it will
be named for a backup directly to disk.

--
Andrew J. Kelly SQL MVP

Show quote

"Michael" <Mich***@discussions.microsoft.com> wrote in message
news:CA5C0B7A-7C12-4F17-A951-3B2F98D5DD13@microsoft.com...
> Hi,
>
> I was just wondering could someone tell me what the
> TO DISK = N part of the statement below is doing ?
>
> TO DISK = N'C:\Test SQL Backups\Diff
> Backups\Northwind\NorthwindDiff1200.bak'
>
> Thanks
>
>