MSSQL 2000 Backup
Lately, I have been having trouble backing up MS SQL 2000 files with ntbackup – running on Windows Server 2000.
As it happens, there is an easy way to deal with this. By modifying the key HKEY_CURRENT_USER\Software\Microsoft\Ntbackup\Backup Engine to 1, backup will deal with each file – even if it is in use!
Of course, I still stop and start the SQL service to ensure that the file is not being modified. I’m not really confident that it works that well…
Related posts:
- No More Lost Deleted Files in Ubuntu I had a shocking error of judgement this morning when...
Related posts brought to you by Yet Another Related Posts Plugin.
You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
