backup database NorthWind to disk=D:\Temp\20031021NorthWind.bak'
backup database NorthWind to disk='D:\Temp\20031021NorthWind.bak'抱什么错?
Server: Msg 3201, Level 16, State 1, Line 1 Cannot open backup device 'D:\Temp\20031021NorthWind.bak'. Device error or device off-line. See the SQL Server error log for more details. Server: Msg 3013, Level 16, State 1, Line 1 BACKUP DATABASE is terminating abnormally. 我的英文不好,这是什么意思??
use master go backup database NorthWind to disk='D:\20031021NorthWind.bak' --报错是应为你没有temp目录
BACKUP DATABASE Northwind TO DISK = 'c:\Northwind.bak' RESTORE FILELISTONLY FROM DISK = 'c:\Northwind.bak' RESTORE DATABASE TestDB FROM DISK = 'c:\Northwind.bak' WITH MOVE 'Northwind' TO 'c:\test\testdb.mdf', MOVE 'Northwind_log' TO 'c:\test\testdb.ldf' GO
Cannot open backup device 'D:\Temp\20031021NorthWind.bak'. Device error or device off-line. See the SQL Server error log for more details.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
我的英文不好,这是什么意思??
master
go
backup database NorthWind to disk='D:\20031021NorthWind.bak'
--报错是应为你没有temp目录
TO DISK = 'c:\Northwind.bak'
RESTORE FILELISTONLY
FROM DISK = 'c:\Northwind.bak'
RESTORE DATABASE TestDB
FROM DISK = 'c:\Northwind.bak'
WITH MOVE 'Northwind' TO 'c:\test\testdb.mdf',
MOVE 'Northwind_log' TO 'c:\test\testdb.ldf'
GO