SQL 2012 Express backup help.
Hi, We have been asked to go from SQL 2008r2 to SQL 2012 Express by our LA. They have sent us migration instructions and pointed me to a backup script by Support.net. I have installed a test server and done a test migration and all is OK but when I run the backup script I have no idea where it is storing the backup.
This is the script
"C:\Program Files\Microsoft SQL Server\MSSQL11.SQL2012\MSSQL\Binn\DBATTACH.exe" /SERVER="WIN-R7C8IKOT6K0\sql2012" /DATABASE="SIMS" /BACKUP /AUTO /TRUSTED
if ERRORLEVEL 1 GOTO :ERROR
1/7/2014 SupportNet - Solution Detail http://support.capitaes.co.uk/websup...29316.xmlFalse
ECHO BACKUP NOT CREATED