BACKUP DATABASE 数据库名
TO DISK = ' g:/DBBack0930.bak '
RESTORE FILELISTONLY
FROM DISK = ' g:/DBBack0930.bak '
RESTORE DATABASE 数据库名
FROM DISK = ' g:/DBBack0930.bak '
WITH MOVE ' DBTest ' TO ' E:/Program Files/Microsoft SQL Server2005/Data/DBTest.mdf ' ,
MOVE ' DBTest_log ' TO ' E:/Program Files/Microsoft SQL Server2005/Data/DBTest_log.ldf '
GO