Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how can i backup SQL 2005 Express?

Status
Not open for further replies.

LioriK

IS-IT--Management
Jan 21, 2008
45
IL
Hi All,

I'm using Legato Networker ver.7.4 sp4 and i'm trying to backup SQL Express 2005 and i got errors:

* xxxxxxx:MSSQL: 1 retry attempted
xxxxxxx:MSSQL:: No full backups of this save set were found in the media database; performing a full backup
* xxxxxxx:MSSQL: 43708:nsrsqlsv:Start time: Thu Mar 19 09:16:21 2009
* xxxxxxx:MSSQL: 43621:nsrsqlsv:Computer Name: xxxxxx User Name: SYSTEM
* xxxxxx:MSSQL: 29085:nsrsqlsv:Microsoft SQL Server Provider error:
* xxxx:MSSQL: 38006:nsrsqlsv:Named Pipes Provider: Could not open a connection to SQL Server [2]. .
* xxxxx:MSSQL: 38006:nsrsqlsv:An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections..
* xxxxx:MSSQL: 38006:nsrsqlsv:Login timeout expired.
* xxxxx:MSSQL: 67945:nsrsqlsv:Cannot login to SQL Server Default Instance.
* xxxxxx:MSSQL: 43709:nsrsqlsv:Stop time: Thu Mar 19 09:16:31 2009
* xxxxxx:MSSQL:

I enabled Remote connections.
Can you please tell how to fix this problem?

Thanks, Lior.
 
You try to connect with username=SYSTEM.
Chjange your client settings and connect with an server or domain admin.
 
I tried to connect with a domain user & local user,
this didn't helped.
do you have any other solution for this?

Thanks, Lior.
 
Have you tried specifying the saveset as MSSQL$SQLEXPRESS: instead of MSSQL:?

Can you perform a manual backup of databases through the Networker Module for MSSQL?

Do flat-file backups work for the same client?

Take a look at INF: TCP Ports Needed for Communication to SQL Server Through a Firewall -
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top