All the sql related files are there and space is also there.

and one more error "Status= Recovery Pending "

when i ran the query

select * from sysdatabases

your SQL Server Agent Job log is probably full.

or else

try to restart the server or the sql servcice it may work.:D

The Ntbackup.exe operation may break the differential backup chain of a SQL Server database and may invalidate the differential backups when you perform a snapshot backup of the database

check...

Vidya sagar,

Good explanation of the solution even i have also learnt a lot.

Thanks vidya

you can copy entire database contents by using export wizard.

Choose destination db to which data is copied and run the wizard.

U can also save package as SSIS and select...

you mean u want the version information from sql server 2005

run

select @@version.

u can find the version.

Mani,

The link provided by u is good.

🙂

you can restore full backup then differential and log backup to restore recent changes.

Restoring full backup does not give latest data so u can restore diff and log backup also.

Thanks:P

Hi,

You find in microsoft.com and search in sqltips.com long back i got the list of version there.

sql 2005 has

1.compact edition

2.standard edition

3.workgroup edition

4.Express edition

5.Enterprise edition

for more information check in google.

Thanks:P

Hi,

Just take a Full backup and then differential backup and see whether u r able to take or not manually.So that we can make out wat exaclty is the...

Pls check the path may be their may be the issue.sometimes the log may be full,no space.

Hey marcelo,

Is that working let me know so that i can solve ur problem if not.:cool:

To manage jobs in 2005 go SMS and login and their we can find the sql server agent -> double click on that you can find their option like...

Tell me exactly what is the problem let me try to solve pls.

I think the issue is with the version the instance showiing error version is 9.0.1399 and other instance in which maintainance job ran fine version is 9.0.3054

need to download latest...