THanks for the Info... This was DEV envoronment . ANd I have already revised the Backup strategy as Full Backup once a week. I will also look in to putting...

Thnanks for all the Info. I did a reload of the table from other source.

Regards

Kay

Thank you all for the Info..

Regards

Kay

Thanks for all the Info Sachnam

Its Distribution Database..I am looking for

I didn't know it was a system database .....

Just wanted to check,,,,, can we back up this DB ?? is it necessary ??

ANyways...

No luck ,,, even if I open a new window.

I think this is the Database created when a distributor is configuired in Replication. But ,, Not sure if it's hidden...

I check the command,,, It shows uo as ONLINE. ANd I did the resfresh as you said. It still doesn't show up .

DOes it belong to the Replication ???...

Got a better way of verifying this. Get in to the Job history and drop down the Job details and it shows up the Litespeed info if it has been...

THank you all for the help.

I differentiated them by the T-SQL statement and SP used for the backup .

regards

Kay

I queried the backupset Table . It showed up as the 4608 as the Software vendor ID for all the rows . Its the code number for SQL server ....

Its a SQL server enterprise edition (64 bit) .

Hi ,

I checked the server name using the PING-axxx.xxx.xxx.xxx . It showed up the FQDN with the correct IP .

So, what else can be checked ??

Thanks for the replies....

Regards

Rahul