SQL Server Performance Forum – Threads Archive
Ways to update mdf/ldf datetimestampWe are looking for a way to update the mdf/ldf files without updating the database. I know the "touch" command does this, but I was wondering if there was anything in SQL Server that could be done. We need this update to verify the cloning occurred for the current day. Any help is appreciated.
Those files are associated with SQL Server process and will not be possible to open up by any other process until they are detached, if there are any then it will mark the data files are corrupted by SQL when you try to attach them. Explain what is your requirement in detail, if you have backup of database then that assures data is safe. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
Are you talking about Disk (HW) cloning? or data cloning? MohammedU.
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.