sql备份还原脚本

RESTORE DATABASE [loudi]
FROM DISK = N'D:\SqlServiceData\Loudi20210930\2021_09_30_224500_9096001.bak'
WITH replace,
MOVE N'loudibak' TO N'D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\loudi.mdf',
MOVE N'loudibak_log' TO N'D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\loudi.ldf'
-- NOUNLOAD, REPLACE, STATS = 10
--GO

RESTORE FILELISTONLY FROM DISK = N'D:\SqlServiceData\Loudi20210930\2021_09_30_224500_9096001.bak'