backup database Northwind
to d:\databak\
with name=Mydata.bak
执行上面的备份程序后,出现提示:
服务器: 消息 170,级别 15,状态 1,行 2
第 2 行: 'd:' 附近有语法错误。
请问,错在哪里?谢谢!
------解决方案--------------------
--请参考这个
BACKUP DATABASE Northwind TO
DISK = N'D:\SQL_BAK\db_bak\MSSQL_P\Northwind.bak' WITH NOFORMAT, NOINIT,
NAME = N'Northwind-完整 数据库 备份',
SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
------解决方案--------------------
BACKUP DATABASE [AdventureWorks2008R2] TO DISK = N'D:\AdventureWorks2008R2_20131108.bak' WITH NOFORMAT, NOINIT, NAME = N'AdventureWorks2008R2-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
------解决方案--------------------
最最起码你少了个disk关键字
------解决方案--------------------
改成这样试试:
backup database Northwind
to disk = 'd:\databak\Mydata.bak'
with format