Use Sqldmo 你要先添加Sqldmo的引用才行 还要注意你的Sqlserver要打sp3才行,不然运行会报错的
我自己写了一个本机备份的恢复的程序,可以备份整个局域网内某一个SqlServer服务器,
-- Create a logical backup device for the full MyNwind backup. USE master EXEC sp_addumpdevice 'disk', 'MyNwind_1', DISK ='c:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\MyNwind_1.dat'-- Back up the full MyNwind database. BACKUP DATABASE MyNwind TO MyNwind_1--RESTORE the full MyNwind database. RESTORE DATABASE MyNwind FROM MyNwind_1
backup database databasename to disk='d:\test.bak'restore database databasename from disk='d:\test.bak'
BACKUP DATABASE db_name To db_path RESTORE DATABASE db_name FROM db_path
你要先添加Sqldmo的引用才行
还要注意你的Sqlserver要打sp3才行,不然运行会报错的
USE master
EXEC sp_addumpdevice 'disk', 'MyNwind_1',
DISK ='c:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\MyNwind_1.dat'-- Back up the full MyNwind database.
BACKUP DATABASE MyNwind TO MyNwind_1--RESTORE the full MyNwind database.
RESTORE DATABASE MyNwind
FROM MyNwind_1
to disk='d:\test.bak'restore database databasename
from disk='d:\test.bak'
RESTORE DATABASE db_name FROM db_path
老兄, 你不是吧,不用语句谁都会~~~点鼠标的事当游戏玩