Sunday, February 19, 2012

Backup/Restore databse - "physical_backup_device_name"

Hi,
I ran into a command today like
RESTORE DATABASE testdb FROM DISK = N'E:\MsSQLServer\Backup\MyDb.bak'
WITH FILE = 7....
Does anyone know what the letter "N", right before the
physical_backup_device_name 'E:\MsSQLServer\Backup\MyDb.bak', is
for?
Thanks in advance!
TonyIt indicates that the following string is Unicode.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
<xtonysun@.gmail.com> wrote in message
news:1172181091.530376.165090@.v45g2000cwv.googlegroups.com...
> Hi,
> I ran into a command today like
> RESTORE DATABASE testdb FROM DISK = N'E:\MsSQLServer\Backup\MyDb.bak'
> WITH FILE = 7....
> Does anyone know what the letter "N", right before the
> physical_backup_device_name 'E:\MsSQLServer\Backup\MyDb.bak', is
> for?
> Thanks in advance!
> Tony
>|||On Feb 22, 4:17 pm, "Geoff N. Hiten" <SQLCrafts...@.gmail.com> wrote:
> It indicates that the following string is Unicode.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> <xtony...@.gmail.com> wrote in message
> news:1172181091.530376.165090@.v45g2000cwv.googlegroups.com...
>
> > Hi,
> > I ran into a command today like
> > RESTORE DATABASE testdb FROM DISK = N'E:\MsSQLServer\Backup\MyDb.bak'
> > WITH FILE = 7....
> > Does anyone know what the letter "N", right before the
> > physical_backup_device_name 'E:\MsSQLServer\Backup\MyDb.bak', is
> > for?
> > Thanks in advance!
> > Tony- Hide quoted text -
> - Show quoted text -
Thanks!

No comments:

Post a Comment