Are you on a cluster?

One of the reason for SQL server restarts are issues with MSDTC in a cluster.

Also you can check for eventvwr logs during the specific restart you...

You can only have 'Full Safety DB Mirroring' in SQL Server 2005 SE, which means that you will need a Witness server if using standard edition.

If the database has a snapshot created against it, you would need to drop & recreate it.

Agree with Meredith, My 776GB db nightly backup takes just over an hour with Litespeed, would recommend using that.

Licensing depends on the # of physical processors which is = to the # of proc slots on motherboard.

Easiest thing to do is if Dell Server, Start-All Programs- Dell Openmanage...

Run profiler from your local computer only not by RDPing into the server.

Running sql profiler on prod by RDP can be tricky, But I would consider running it for a...

Have you tried Synchronous mirroring (Full Safety) using a Witness Server which brings the mirrored server online in case of a issue?

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/754a003f-fe51-4d10-975a-f6b8c04ebd35.htm

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/b796c829-ef3a-405c-a784-48286d4fb2b9.htm

SORT_IN_TEMPDB & ONLINE=ON are independent of each other. If SORT_IN_TEMPDB is ON, then tempdb would be used if the operation cannot be completed in memory (refer above link). This...

Issue Solved :

1. Added a new step to the existing Alluserdb backup Job for copying to the different drive. Created the folders required on the drive. Choose, T-sql as TYPE...

This is what I have tried so far :

I created a test maintenance plan for a test db backup.

I added a new step to the existing job for backup...

Thx for the info. guyz. I will check up on it.

How about some details?

Can you give details?

I have tried ROBOCOPY before however I could not give time to understand its commands , It would save a lot of time for me if you...

Yo, how about some valuable suggestions!!

Shamas, your comment doesn't make sense.

Steve, I think you should clarify as you went into all this trouble of making a video which is confusing people in such a...