Thanks all 😀

http://msdn.microsoft.com/en-us/library/ms144267(SQL.90).aspx

Use this

http://www.mssqltips.com/tip.asp?tip=1100

what man!!!!!!!! njn paranju tannatokke nee marannu poyo

Thanks man !!!!!!!! :w00t:

you got it!!!!!;-)

this is what actually i want 🙂

It includes backup databases,monitoring the servers,monitoring diskspace for proper running of servers.

1. Check OS Event Logs, SQL Server Logs, and Security Logs for unusual events.

2. Verify that all scheduled jobs...

But this not what i meant for

THANKS buddy

The server might be down

SK,

you have to take a full backup follwed by a transaction log backup of primary database and restore it in mirror database "with no recovery" mode.Then perform mirroring

http://msdn.microsoft.com/en-us/library/5h52hef8(VS.80).aspx

Really you are superb krishna:-D

Thanks!!!!!!!!! It was actually my mistake.I got what all i want from the profiler itself.i didnt checked it fully before.:-)

Use database snapshots

Eswin,

http://msdn.microsoft.com/en-us/library/ms187885.aspx

Checkout this