Backing up MS SQL Server causes error

Asked By bautistalawrence 10 points N/A Posted on - 02/11/2012

Hello,

My customer installed Ahsay OBM 5.5.8.0 on Windows XP to backup MS SQL Server 2010 in this machine. My OBS server is 5.5.8.0 in version.

 

During the change to a temporary folder, I found error in the backup jobs. The errors are below:

 

1. Info 2011/04/04 08:39 Start [Windows XP (SQL Server 01), OBM 5.5.8.0].
2. Info 2011/04/04 08:39 Start running pre-commands.
3. Info 2011/04/04 08:39 Finished running pre-commands.
4. Error 2011/04/04 08:39 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'.
5. Error 2011/04/04 08:39 Database of "(local)" not found.
6. Info 2011/04/04 08:39 Start running post-commands.
7. Info 2011/04/04 08:39 Finished running post-commands.
8. Warn 2011/04/04 08:39 Path "D:Temp1292924031093" does not exist.
9. Warn 2011/04/04 08:39 Path "D:Temp1292924031093" does not exist.
10. Warn 2011/04/04 08:39 No file is being upload.
11. Error 2011/04/04 08:39 Backup completed with error(s).

Please give me a solution if anyone has it.

Thanks in advance.

• Status: Open
• Question Views: 2414
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Tony clever 20 points N/A #96485

Backing up MS SQL Server causes error

Hi friend,

1. Check your SQL server is running or not. If your SQL server is not running then this problem will cause as it shows. Your errors are in a pattern that is making me think like that may be your SQL server is not running.

2. Now find out that which SQL server you are running. Just search its administrative support with your version. You can visit this website for information.

3. Other possible reason is that may be you have syntax error of a Transact-SQL statement. Incorrect statement shows that kind of error.

4. Database management error is other option. SQL can’t find database for user ‘sa’. To solve this problem go to configuration page and modify it as your database name and path.

About Tony clever

Questions
0

Answers
168

Best Answers
51

• Vote Up 0 Vote Down

• Posted on - 02/11/2012
• Question Category: MS SQL Server