SQL server mdf file modifed date

SQL server mdf file modifed date

the modified date of mdf, ndf (sql server database files) only changes when
1. Database turns online(server restart, new db, being restored)
2. file expanded/shrunk
3. DBCC checkdb

---will update if notice further factor to change the modified date of database data file.

Comments

Post a Comment

Popular posts from this blog

PowerBI license

 1. on premise license covers by enterprise server with SA 2. Office 365 E5 license covers powerbi Pro 10GB limit, data can be refreshed max 8 times a day 3. free version is for single user 10GB limit
Read more

GENERATE RSA KEYS WITH SSH BY USING PUTTYGEN

 GENERATE RSA KEYS WITH SSH BY USING PUTTYGEN  5.12.3.9.1 Autologin (TFDBA runbook Unix/Linux Tips) 1. Use puttygen to create keys, move mouse to create random 2. Save keys public and private, if doesn’t want passphrase to login using keys, ignore the passphrase 3. Copy and paste the output on the screen of puttygen to clipboard (for HPUX use "...\putty\PuttyKeysPublicPrivate\authorized_keys" or linux one for linux,  open and copy and paste) 4. In Linux Server, under your name, create $HOME/.ssh/authorized_keys file and paste step 3 to it and save Same as HPUX, for root it is /.ssh/authorized_keys, append the keys (paste below existing if there is) 5. In putty ->connection->SSH->Auth load the private key  :\putty\PuttyKeysPublicPrivate\testCernerPrivateKey.ppk 6. Save session. (connection->data_autologin name, add your loginname)
Read more

script to stop/disable spooler service on all servers not required in regards to Print Spooler Vulnerability

Image
  script to stop/disable spooler service on all servers not required regarding the Print Nightmare vulnerability,  I have deal with all 226 sql servers and 12 oracle servers on windows, so resue one of my ps script to stop /disable spooler service on all servers. this also helps to disable spooler on some of other 10000+ windows machines we have.  Windows Print Spooler Remote Code Execution Vulnerability  https://msrc.microsoft.com/update-guide/vulnerability/CVE-2021-34527  step1, create a list of servers to change in text file with one servername in a line, saved it toc:\sql\serverlist0.txt step 2. copy below script to power script ISE step 3. run it, see screenshot $service = "Spooler" $text =Get-Content C:\sql\serverlist0.txt $TotalComputers = $text .Length write-host "the total number of computers is $TotalComputers " For ( $i = 0 ; $i -lt $text .Length; $i ++) { $Computer = $text [ $i ] Write-Host "Working on $...
Read more