我刚刚恢复了一个数据库,但后来我注意到 create_date 仍然是恢复前的日期。
有没有办法可以将 create_date 更改为新数据库(恢复后)?
这是脚本:
USE [master]
RESTORE DATABASE [SUPT_S01_Radhe]
FROM DISK = N'\\krishna3.radhe.co.uk\support\MM_Backups\S01__JagannathaeCA_12122023.bak'
WITH FILE = 1,
MOVE N'radhe_Data' TO N'Y:\DATA\SUPT_S01_radhe_shyam_Data.mdf',
MOVE N'radhe_ChangeLog' TO N'W\:\DATA\SUPT_S01_radhe_shyam_ChangeLog.ndf',
MOVE N'radhe_Docs' TO N'Z:\DATA\SUPT_S01_radhe_shyame_Docs.ndf',
MOVE N'radhe_Log' TO N'P:\LOGS\SUPT_S01_radhe_shyam_Log.ldf',
NOUNLOAD, REPLACE, STATS = 1
select name, database_id, create_date from sys.databases d
where d.database_id in (1,2,3,4,8)