1) DTS

2) SSIS

3) SSRS report with time subscription in excel format.

1) can i do the mirroring and replication in the same server by installing the one more instance .

=> Yes but depend on database size which u are mirroring.

1-Is it possbile to add Notification email to the reports that has been created in SSRS. Example:We have set up a report which will be sent to the client through...

1)Configure email if sql agent job fail.

2) check job history insert into one table then on insertion show alert.

1) check all process of corresponding database using sp_who.

2) check any process is not suspended ?

3) check query plan also

How to configure SSRS for Disaster recovery :-

You can scale out report server to many server.

hi,

1)First Take backup of current database with to NewTestDbNew.bak

BACKUP DATABASE [oldTestDb] TO DISK = N'D:\NewTestDbNew.bak' WITH NOFORMAT, NOINIT, SKIP, NOREWIND, NOUNLOAD, STATS = 10

GO

2) Restore...

hi,

Thank you very much...

Rds,

Dinesh

Nice..............

I want sql statement from Rdl file then what to do ??

i check all process but no process shown in sysprocesses and Sp_who/sp_who2.

I had check database id from.

select * from sys.databases

then

select * from sys.sysprocesses WHERE dbid = 84

SELECT * FROM sys.dm_exec_requests...

i am sending email by ssrs ,it is working in in domain but it is not working for outside .what should be done.

i am sending email by ssrs ,it is working in in domain but it is not working for outside .what should be done.

Dear SSC Veteran,

Thanks A Lot.

Dinesh

Msg 22051, Level 16, State 1, Line 0

Attachment file C:\dineshlink.txt is invalid.

Please let me know solution