最简单的方法:
1.STOP MSSQLSERVER SERVICE,
2.拷贝你所需要的DATABASE.MDF和DATABASELOG.LDF文件到另外一个路径,
3.SP_ATTACH_DB 'NEWNAME','data path','log path'
1.STOP MSSQLSERVER SERVICE,
2.拷贝你所需要的DATABASE.MDF和DATABASELOG.LDF文件到另外一个路径,
3.SP_ATTACH_DB 'NEWNAME','data path','log path'
DROP DATABASE [test]
GOCREATE DATABASE [test] ON (NAME = N'test_dat', FILENAME = N'd:\Program Files\Microsoft SQL Server\MSSQL$RAIN\data\test.mdf' , SIZE = 7, FILEGROWTH = 10%) LOG ON (NAME = N'test_log', FILENAME = N'd:\Program Files\Microsoft SQL Server\MSSQL$RAIN\data\test.ldf' , SIZE = 4, FILEGROWTH = 10%)
GO
GO
CREATE DATABASE Products
ON
( NAME = prods_dat,
FILENAME = 'c:\program files\microsoft sql server\mssql\data\prods.mdf',
SIZE = 4,
MAXSIZE = 10,
FILEGROWTH = 1 )
GO
GO---拷贝路径一定要对
exec xp_cmdshell 'copy c:\program files\microsoft sql server\mssql\data\你的旧库的文件.mdf c:\program files\microsoft sql server\mssql\data\你的新库的文件.mdf'
go--附加还原
CREATE DATABASE 你的旧库名
ON PRIMARY (FILENAME = 'c:\program files\microsoft sql server\mssql\data\你的旧库的文件.mdf')
FOR ATTACH
GO--附加新的库
CREATE DATABASE 你的新库名
ON PRIMARY (FILENAME = 'c:\program files\microsoft sql server\mssql\data\你的新库的文件.mdf')
FOR ATTACH
GO