Once a week, I drop the three instances on our SQL Server 2000 production machine for a cold backup. I do so using the following script:
net stop "SQLSERVERAGENT"
net stop "SQLAGENT$MIS"
net stop "SQLAGENT$ADP"
net stop "MSSQLSERVER"
net stop "MSSQL$MIS"
net stop "MSSQL$ADP"
Within the last month I have had issues of databases being broken during the cold backup. First of all these instances to appear to go down. The event logs note both the the request and completion of the services stopping. This is done 15 minutes before the backup starts. Once the backup starts there are both data files and xlogs file that are locked and cannot be backed up. But not all of the files, for instance the files for one instance may backup, but not for another.
Can anyone tell me if a session in progress can cause an instance to wait for the session to complete before allowing a shutdown?