Probably there is some resource that is acquiring lock on the table which is preventing the truncate statement on the table.

You may debug using SQL Profiler to verify if there...

I guess you cannot recover the table2 from the filegroup as the filegroup recovery will need a T-Log backup. If you take a T-log backup, that will also contain the...

Try using :

RESTORE VERIFYONLY FROM < backup_device > [ ,...n ]

This only checks the backup to see if the backup file you have is complete.

--Kishore

You will have to take a Transaction Log backup of the database before restoring any file/filegroup backup on the database. This is the normal behaviour of Sql Server 2k.

Also...

when are your full backups been taken ?

I would recommend having separate T-Log backup files. Since you have 1 per hour, you could have 24 in a day, depending on...

You can have a maximum of 32,767 databases per Instance of Sql Server 7.0 and SQL Server 2000.

--Kishore

You can configure log shipping only on one database at a time. If you select more than one database, the log shipping option on the wizard is disabled.

--Kishore

I am not sure, but I guess, when you remove the network cable of the Publisher, the transaction log backups will contiue to happen (provided your T-log backups destination is on...

What kind of maintainence plans are you looking for ? You can use some of the DBCC commands like DBCC checkdb, DBCC dbreindex, etc. in ur plan....

--Kishore

Can you list all the backup files U have at present and their backup datetime. We can then help you better....

--Kishore

Yes. You can use the use backup database command in QA. But if you need to schedule it for future use, you can schedule a job rather than everytime passing...

Can you provide more information like the table structure and what exactly you want in your output. So that we can help you better.

--Kishore

Yes at times I have also got similar problems. What you can do is that still mention the path of the drive and folder name manually and try taking a...

Under EM, right click on SQL Server Group and click on 'New SQl Server Registration'. Then you can mention the name of the remote server and connect either using Windows...

Yes. If the job script file contains the -DelBkUps parameter, then the .trn files should be deleted at the scheduled interval.

However, if the job itself is failing, then...