Problem with batch backup or SIMS.net using DBAttach

[GreenICT]

Hi,

 

I'm trying to create a .bat file to backup the SIMS.net database using the DBAttach facility. I've cribbed the dbattach command from someone else's batch file but I've having trouble with the username and password. When I double click my .bat file it just shows me the Database Management Utility screen and when I click connect it says login failed for user Backup. I created user "Backup" using System Manager in SIMS.net and made this user a System Manager. Should I have created this Backup user some other way? Or does this user have to have permissions other than those of a system manager?

 

Any help appreciated

[MkII]

Isn't there a dedicated backup user?

[steve]

This is our backup script:

 

dbattach.exe /user:"backup" /password:"password" /backup /SERVER:"server_name" /DATABASE:"sims" /AUTO

 

No specific rights for the backup user.

[Heebeejeebee]

We created a dedicated "backup" user (as recommended by Capita) and use a bach file for backing up. One of their KBs explains why they think it's necessary. It isn't compulsory but we thought it more secure to use a limited SIMS user account since the password is in plain text. We also put the batch file in an area where only admins have access to.

 

Our batch file is scheduled to run over night.

 

I also make a copy of the Docstorage folder at the same time so that there's always a matched pair if we need to restore.

 

HBJB

[GreenICT]

Thank you all for your replies. I checked out the capita website for the knowledge base article and found it (KB29316). I followed the instuctions for creating the user and then copied their batch file. All worked fine. Still not sure if the problem was with the user or the batch file itself, but anyway I'm happy as I've got a working backup!

[superfletch]

 

dbattach.exe /user:"backup" /password:"password" /backup /SERVER:"server_name" /DATABASE:"sims" /AUTO

 

 

 

Shouldn't the Server part have read - Server_name\Instance_name?

 

EDIT - Sorry just saw the age of this thread....