|
Posted by NiTiN on 07/25/06 07:24
The error is the double quotes! You need to use single quotes to
specify the filename. The statement should be rewritten as:
BACKUP DATABASE DemoSQLServer TO DISK = 'G:\DemoSQLServer.bak'
N.I.T.I.N.
RAM wrote:
> Hello,
> I am learning SQL Server 2005. I need to know how to make a backup of
> a database. I tried (according to my book):
> BACKUP DATABASE DemoSQLServer TO DISK = "G:\DemoSQLServer.bak"
> But I got error:
> Incorrect syntax near 'G:\DemoSQLServer.bak'.
> Please help.
> Thank you very much.
> /RAM/
Navigation:
[Reply to this message]
|