[Discover] Database backup issue [Solved]
When a discover database is backed up manually using the dbAttach.exe GUI, the backup completes successfully.
Nightly though, we script a backup to take place using the dbAttach command parameters to back up SIMS and FMS through a batch file. This always works perfectly and I have modified the script to also backup the new Discover database. The command is exactly the same for the SIMS and FMS backup minus the database name:
When running this through the command prompt, this pops up:
"D:\Program Files\Microsoft SQL Server\MSSQL10.SIMS2008\MSSQL\Binn\ dbattach.exe" /BACKUP /AUTO /SERVER=%COMPUTERNAME%\SIMS2008 /DATABASE=Discover /USER=****** /PASSWORD=******
Has anyone else come across this? Is anyone else successfully backing up Discover this way?
Edit: tested on my local XP machine and I get the same issue. Defiantly some kind of problem with dbAttach.