Hi Adam,

First of all thanks for your reply...we just want to run this job for temp. basis...so We are ok if our mails get full...

You can know the number of instance by looking services in sql server configuration manager

select * from log_shipping_plan_history put this statement into job

This is a very big mistake...Now the best thing you can do is to apply full backup and all the log backups manually

...As a DBA you should be very careful....From...

I had the same problem too. Then I came to know that my backup file was corrupted...So that I restored that database to the second current backup and then I...

I have the same question....Any answer would be appreciated.

Check the Activity Monitor

This is the command that process does

dbcc dbreindex(N'[dbo].[table_name]', N'', 90, sorted_data_reorg)

Can I kill that?

Certification exams are very beneficial to improve our knowledge.....For this exams we have to read every small things....Otherwise we wan't read everything....

I read this book...It is very good book and covered almost all topics for SSIS. A very good book...Recommanded by me for SSIS.

In job history it only says that sqlmaint.exe failed....nothing else...Any ideas folks??

The destination is up as well as if I restart job then also it runs successfully....The only problem is that it fails randomly, at aleast 2-3 times a day..

Easier one...njoi...

USE [Databasename]

GO

SELECT [name] FROM sys.tables WHERE [type] = 'U'

Here is another one..

select name,recovery_model_desc as Recovery_mode from sys.databases order by name

I found for SQL server 2000 now.

Here is the script

SELECT [name] AS [DatabaseName], CONVERT(SYSNAME, DATABASEPROPERTYEX(N''+ [name] + '', 'Recovery')) AS [RecoveryModel] FROM master.dbo.sysdatabases where CONVERT(SYSNAME, DATABASEPROPERTYEX(N''+ [name] + '', 'Recovery'))<>'full'