Unsolved

This post is more than 5 years old

7 Posts

1395

May 18th, 2006 04:00

Problems doing a backup of a SQL database

Hi
I'm getting a message that the database I want to backup doesn't exist running a group with the Legato server. If I try to do by the client there is not problem to backup it. What could be?. The database I'm sure that is created, because I do it.

Thanks,

4 Operator

 • 

14.3K Posts

May 18th, 2006 04:00

Send us your client resource configuration and SQL log from the failing backup when running from server.

7 Posts

May 18th, 2006 05:00

I have tried with
A) MSSQL: With this option I do backup of all database minus the New one I have created

B)MSSQL: database name With this I get the error

2 Intern

 • 

1.1K Posts

May 18th, 2006 05:00

My guess is you have some error in your group resource set-up which is responsible for the error. Check you have set it up against the correct server, that the correct name is given for the database you are backing up and that you have configured the correct backup command.

2 Intern

 • 

1.1K Posts

May 18th, 2006 05:00

Just one thing I vaguely recall seeing before... Did you add a space to the end of the line where you specified your database name? If so remove it.

Have you tried backing up a different specific database with success?

7 Posts

May 18th, 2006 05:00

If I put only MSSQL: should do all the databases, but this one no.

7 Posts

May 18th, 2006 05:00

Here you have

* sql.pruebas.local:MSSQL:prueba nsrsqlsv: Database prueba does not exist.
* sql.prueba.local:MSSQL:prueba At least 1 valid backup target is required
* sql.prueba.local:MSSQL:prueba 1 retry attempted
* sql.prueba.local:MSSQL:prueba nsrsqlsv: Database prueba does not exist.
* sql.prueba.local:MSSQL:prueba At least 1 valid backup target is required

SQL agent version is 4.0.1.294

Thanks for your help

4 Operator

 • 

14.3K Posts

May 18th, 2006 05:00

My domain for testing is prueba.local and the
database I have created is also named as prueba.


Check again what you sent; if you did pure copy and paste you will that first line is mentioning pruebas. So, from where is that s coming up?

4 Operator

 • 

14.3K Posts

May 18th, 2006 05:00

Can you post the error please. Also, what version if module do you use and what version of SQL is that?

7 Posts

May 18th, 2006 05:00

My domain for testing is prueba.local and the database I have created is also named as prueba.

4 Operator

 • 

14.3K Posts

May 18th, 2006 05:00

To me that looks like savegrp log - SQL module log is log on the client and it is called nsrsqlsv.log I believe (or something like that) - I believe it is in applogs directory. Check it out.

Also your output is strange as it calls client domain first pruebas and then prueba. What is going on there? :D

2 Intern

 • 

1.1K Posts

May 18th, 2006 05:00

Is it possible we can see a log excerpt or resource configuration? You have not given us a great deal to go on so far!
No Events found!

Top