34,576
社区成员
发帖
与我相关
我的任务
分享怎么让数据库还原（简单）
我重装了系统，sqlserver也重装了。原来我对aaa数据库备份过一次，生成了SQL Script File文件，文件还在。请问怎么还原数据库呢？小弟初学，请多多帮忙！
...全文
请发表友善的回复…
发表回复
lvcheng606717 2003-10-19
- 打赏
- 举报
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'
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'
lvcheng606717 2003-10-19
- 打赏
- 举报
restore database ->还原为数据库：[数据库名]，选from device -> 选择设备 -〉添加 -〉选文件 -〉OK!
welyngj 2003-10-19
- 打赏
- 举报
restore database dbname from disk='address\备份文件名'
