10-27-2008 12:09 PM
I have the option of creating an "image" back copy of my hard drive. However, I get an "sql database lock" when trying to do this back up.
I believe one can temporarily "unlock" the database - but I dont know how -- can anyone please help?
10-27-2008 01:44 PM
10-27-2008 02:41 PM
Before the image: NET STOP MSSQL$ACT7
After the image: NET START MSSQL$ACT7
10-27-2008 06:33 PM
That should work... to do it manually.
If the backup is automated, you can put the lines in .BAT files and run before and after the backup
10-28-2008 10:15 AM
I plan to do this manually -- that is, do NET STOP MSSQL$ACT7, then power down the laptop after doing the image backup.
Will MSSQL$ACT7 start automatically when the laptop is next powered up?
10-31-2008 12:56 AM