Posted by Erland Sommarskog on 07/24/06 22:03

RAM (r_ahimsa_m@poczta.onet.pl) writes:

> 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.

If the book fails, try Books Online.

Generally, in T-SQL, single quote is used as the string delimiter. (Although
it is possible with a legacy setting in force also use double quote as
string delimiter, but this is not recommended.)


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]