Ways to update mdf/ldf datetimestamp | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Ways to update mdf/ldf datetimestamp

We 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.
Kris
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
http://www.SQL-Server-Performance.Com
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.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
]]>