[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 179
  • Last Modified:

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.
0
SupermanTB
Asked:
SupermanTB
  • 4
  • 4
1 Solution
 
tigin44Commented:
the program list only the instances runing  localy...
probably you are using a named instance and you shoould reference it as ...

MACHINE_NAME\INSTANCE_NAME
0
 
HainKurtSr. System AnalystCommented:
when you put .\MSSQLSERVER and click test, do you get success message?
and after that do you see the db list?
0
 
SupermanTBAuthor Commented:
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 as well and no luck.  I believe both the machine name and the instance name are the same (term-server).  I typed in term-server\term-server and got an error.
0
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
HainKurtSr. System AnalystCommented:
"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?
0
 
SupermanTBAuthor Commented:
The others at the ones I mentioned in the original post.  To my knowledge there are no other SQL servers.
0
 
HainKurtSr. System AnalystCommented:
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...
0
 
SupermanTBAuthor Commented:
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.
0
 
HainKurtSr. System AnalystCommented:
check this

http://www.sqlbackupandftp.com/screenshots/

put the same connection info as you do in SSMS
0
 
SupermanTBAuthor Commented:
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.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now