我安装了两个实例Server,称为测试和生产。我从测试实例中获取了AdventureWorks数据库的完整备份,并试图将其还原到生产实例中:
RESTORE DATABASE [testikanta] FROM DISK = N'C:\Program\Microsoft SQLServer\MSSQL10.SQL2008TESTI\MSSQL\DATA\AdventureWorks_D
我从微软(AdventureWorks2014.bak)下载了一个演示数据库的备份,以便学习在线教程。SQLServer\MSSQL12.MSSQLSERVER\MSSQL\Backup\AdventureWorks2014.bak'
TO 'C:\Program Files\Microsoft SQLServer\