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/

[Back to original message]