USE master 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