Question
Thread display: Collapse - |
All Answers
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Automatic Backup for SQL Express 2005
c:
cd backup
sqlcmd -i c:\backup\backup.sql
Basically, what it does is just change the directory to C:\Backup then it launches the Backup.sql
Backup.sql contains:
EXEC sp_addumpdevice 'disk', 'dbbu',
'c:\Backup\dbbu.bak'
BACKUP database dbtest TO dbbu
GO
What it does is only "backuping" the database Dbtest to the file Dbbu.back in the path C:\Backup
However, when I launch it, I get an error telling me that An error occured while establishing connection to the server, that might be caused by SQL Server not accepting remote connection, although that I am running the operation locally.
Any ideas ?