首先登陆sqlserver,然后点新建查询,然后输入以下命令,然后点执行参考如下图:
备份完整数据库命令:备份数据库test(数据库名)
BACKUP DATABASE test TO DISK = 'C:\db\test.bak'
导入命令:如果导入的数据库不存在
RESTORE DATABASE [test] FROM DISK = 'C:\db\test.bak' WITH FILE = 1, MOVE 'test' TO 'C:\db\Data\test.mdf', MOVE 'test_log' TO 'C:\db\Log\test.ldf', NOUNLOAD, STATS = 10
如果导入的数据库存在,加replace参数覆盖
RESTORE DATABASE [GameAgent] FROM DISK = 'C:\MSSQL\Bak\zzmj\GameAgent.bak' WITH FILE = 1, MOVE 'GameAgent' TO 'C:\MSSQL\Data\GameAgent.mdf', MOVE 'GameAgent_log' TO 'C:\MSSQL\Log\GameAgent.ldf', NOUNLOAD, STATS = 10, REPLACE