sql server 2000 转 sql server 2005

发表于

Ivan 发表于 2008-2-7 1:53:00

RESTORE DATABASE PAIDC
FROM DISK = 'D:\hosting\站调试\_db_backups\backup.bak'
WITH MOVE 'PAIDC' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\PAIDC.mdf',
MOVE 'PAIDC_log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\PAIDC_log.ldf',
replace