SQL Express Db and shadow copies
When i run a windows backup on our WSUS box which is also running SQL express it lists the Db's as being backed up in the event log and the Db appears on the tape, i haven't tried to restore one yet but i wondered if windows backup with shadow copies can now backup a SQL Express Db or is SQL creating a backup file somewhere else that is then backed up?
I also see this at the start of the backup which leads me to beleive that it is getting a clean copy of the Db.
I know in the past with MSDE on 2k that you needed to either stop the instance or use osql to make the agent backup to a seperate file.
I/O is frozen on database SUSDB. No user action is required. However, if I/O is not resumed promptly, you could cancel the backup.