SupermanTB
asked on
Trying to automate SQL Express 2005 backup
I am very new to SQL and am trying to backup a SQL database. I had the following software recommended to me
http://sqlbackupandftp.com/
It look pretty cut and dry, but I am having trouble connecting to my SQL server. I installed the software on the machine running SQL server and when I try to connect to my SQL server, it doesn't seem to detect the particular instance of SQL server with the information I need to backup. It is detecting a few items (.\MSSQLSERVER, .\MICROSOFTSMLBIZ, .\MSONLINE).
I'm just not sure what to do from here. I've tried inputting various pieces of data that I get from looking at my database SQL Server Management Studio Express, but haven't been successful. Any help would be appreciated.
Thanks.
http://sqlbackupandftp.com/
It look pretty cut and dry, but I am having trouble connecting to my SQL server. I installed the software on the machine running SQL server and when I try to connect to my SQL server, it doesn't seem to detect the particular instance of SQL server with the information I need to backup. It is detecting a few items (.\MSSQLSERVER, .\MICROSOFTSMLBIZ, .\MSONLINE).
I'm just not sure what to do from here. I've tried inputting various pieces of data that I get from looking at my database SQL Server Management Studio Express, but haven't been successful. Any help would be appreciated.
Thanks.
when you put .\MSSQLSERVER and click test, do you get success message?
and after that do you see the db list?
and after that do you see the db list?
ASKER
When I put .\MSSQLSERVER and do the test, it is not successful. On the others, the test is successful and I see the database list.
From what I can tell I have done the MACHINE_NAME\INSTANCE_NAME
From what I can tell I have done the MACHINE_NAME\INSTANCE_NAME
"On the others, the test is successful and I see the database list"
what are others? do you have multiple sql servers on different machines?
what are others? do you have multiple sql servers on different machines?
ASKER
The others at the ones I mentioned in the original post. To my knowledge there are no other SQL servers.
if there is one sql instance on that machine, and after success message, select the db from list, go through wizard steps and run it... it will create backup and send it to ftp site and I guess send email the result...
ASKER
I can connect to the .\MICROSOFTSMLBIZ, .\MSONLINE, but when I do, I don't see the databases I have in my SQL Server Management Studio Express. The databases on those are completely unrelated.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I have tried that. The name of my server is TERM-SERVER. I have entered .\term-server and .\TERM-SERVER\TERM-SERVER and get the same error.
On a related note, I tried this on another server that uses the same SQL based program I am attempting to back up and had no problems. The software detected the SQL server and loaded the proper databases.
On that server, when I open SSMS, the server name is SBSSERVER\SQLEXPRESS, where as on the problem server, the server name is TERM-SERVER.
Actually I just figured it out from comparing the two. The working server has just a "." for the server name. When I entered that, it fixed the problem and immediately pulled up the appropriate databases.
Thanks for your help.
On a related note, I tried this on another server that uses the same SQL based program I am attempting to back up and had no problems. The software detected the SQL server and loaded the proper databases.
On that server, when I open SSMS, the server name is SBSSERVER\SQLEXPRESS, where as on the problem server, the server name is TERM-SERVER.
Actually I just figured it out from comparing the two. The working server has just a "." for the server name. When I entered that, it fixed the problem and immediately pulled up the appropriate databases.
Thanks for your help.
probably you are using a named instance and you shoould reference it as ...
MACHINE_NAME\INSTANCE_NAME