34,837
社区成员




eg: 这里有三个文件
RESTORE DATABASE [newegg]
FROM DISK = N'F:\Restore_DB_Mirror\newegg.bak'
WITH MOVE N'newegg_Data' TO N'E:\DATA\newegg\SQL\newegg_Data.MDF',
MOVE N'newegg_data2' TO N'E:\DATA\newegg\SQL\newegg_Data2.NDF',
MOVE N'newegg_Log' TO N'E:\DATA\newegg\LOG\newegg_Log.LDF',NORECOVERY,STATS=5
GO
select db_name(database_id) as db_name
,name as logic_filename
,physical_name
from sys.master_files