Solved

BCM Backup scrip fails

Posted on 2011-02-22
5
368 Views
Last Modified: 2012-05-11
Hi,

I am getting the folowing errors when running a script to automate the BCM backup. Any ideas?

D:\BCM-Backups>Backup.cmd

D:\BCM-Backups>"c:\program files\microsoft sql server\90\tools\binn\sqlcmd.exe"
-E -S .\MSSMLBIZ -Q"SET NOCOUNT ON; SELECT 'MSSmallBusiness Backup started at -
' + CONVERT(varchar, GETDATE());"  1>"D:\BCM-Backups\MSSmallBusiness_BackupResul
t.txt"
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi
shing a connection to the server. When connecting to SQL Server 2005, this failu
re may be caused by the fact that under the default settings SQL Server does not
 allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.

D:\BCM-Backups>"c:\program files\microsoft sql server\90\tools\binn\sqlcmd.exe"
-E -S .\MSSMLBIZ -Q"BACKUP DATABASE MSSmallBusiness TO  DISK = N'D:\BCM-Backups\
MSSmallBusiness.bak' WITH FORMAT, INIT,  NAME = N'Full Database Backup', SKIP, S
TATS = 10"  1>>"D:\BCM-Backups\MSSmallBusiness_BackupResult.txt"
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi
shing a connection to the server. When connecting to SQL Server 2005, this failu
re may be caused by the fact that under the default settings SQL Server does not
 allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.

D:\BCM-Backups>"c:\program files\microsoft sql server\90\tools\binn\sqlcmd.exe"
-E -S .\MSSMLBIZ -Q"SET NOCOUNT ON; SELECT 'Backup completed at - ' + CONVERT(va
rchar, GETDATE());"  1>>"D:\BCM-Backups\MSSmallBusiness_BackupResult.txt"
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi
shing a connection to the server. When connecting to SQL Server 2005, this failu
re may be caused by the fact that under the default settings SQL Server does not
 allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.

D:\BCM-Backups>REM copy /Z "D:\BCM-Backups\MSSmallBusiness.bak" "<NETWORK_PATH>\
MSSmallBusiness.bak" >>"D:\BCM-Backups\MSSmallBusiness_BackupResult.txt"

D:\BCM-Backups>Backup.cmd

D:\BCM-Backups>"c:\program files\microsoft sql server\90\tools\binn\sqlcmd.exe"
-E -S .\MSSMLBIZ -Q"SET NOCOUNT ON; SELECT 'MSSmallBusiness Backup started at -
' + CONVERT(varchar, GETDATE());"  1>"D:\BCM-Backups\MSSmallBusiness_BackupResul
t.txt"
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi
shing a connection to the server. When connecting to SQL Server 2005, this failu
re may be caused by the fact that under the default settings SQL Server does not
 allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.

D:\BCM-Backups>"c:\program files\microsoft sql server\90\tools\binn\sqlcmd.exe"
-E -S .\MSSMLBIZ -Q"BACKUP DATABASE MSSmallBusiness TO  DISK = N'D:\BCM-Backups\
MSSmallBusiness.bak' WITH FORMAT, INIT,  NAME = N'Full Database Backup', SKIP, S
TATS = 10"  1>>"D:\BCM-Backups\MSSmallBusiness_BackupResult.txt"
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi
shing a connection to the server. When connecting to SQL Server 2005, this failu
re may be caused by the fact that under the default settings SQL Server does not
 allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.

D:\BCM-Backups>"c:\program files\microsoft sql server\90\tools\binn\sqlcmd.exe"
-E -S .\MSSMLBIZ -Q"SET NOCOUNT ON; SELECT 'Backup completed at - ' + CONVERT(va
rchar, GETDATE());"  1>>"D:\BCM-Backups\MSSmallBusiness_BackupResult.txt"
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi
shing a connection to the server. When connecting to SQL Server 2005, this failu
re may be caused by the fact that under the default settings SQL Server does not
 allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.

D:\BCM-Backups>REM copy /Z "D:\BCM-Backups\MSSmallBusiness.bak" "<NETWORK_PATH>\
MSSmallBusiness.bak" >>"D:\BCM-Backups\MSSmallBusiness_BackupResult.txt"
0
Comment
Question by:optimus_nz
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 17

Expert Comment

by:dbaSQL
ID: 34957724
try this to enable remote entry:
EXEC sp_configure 'remote access', 1

0
 

Author Comment

by:optimus_nz
ID: 34965844
Is anywhere special this needs to be entered? Or straight from command line?
0
 
LVL 17

Accepted Solution

by:
dbaSQL earned 500 total points
ID: 34967028
If you've got SSMS, just open a query window, connected to the MSSmallBusiness database, and run that statement.  Just cut/paste it into your query window, and hit the execute button.
0
 

Author Closing Comment

by:optimus_nz
ID: 35087917
Thanks
0
 
LVL 17

Expert Comment

by:dbaSQL
ID: 35088208
My pleasure.
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Read this checklist to learn more about the 15 things you should never include in an email signature.
This article will help to fix the below errors for MS Exchange Server 2013 I. Certificate error "name on the security certificate is invalid or does not match the name of the site" II. Out of Office not working III. Make Internal URLs and Externa…
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question