The best pizza in the country

If you are in seattle, cali area...

the best is CANAM pizzas(anybody living that side would know wat im talkin abt)

In Chicago, GIORDANO'S r d...

@ RTaylor

In dumps also, we have to study, study and study....LOL

Regards,

Sushant

Configure backup through the maintenance plan and in that

allow it to send email to operator through the notify operator task, in case the backup fails.

Regards,

Sushant

@ sundaram

Choose the mixed mode of authentication

Windows and the sql server

Regards

Sushant

do any1 hav MCITP dumps?

Regards,

Sushant

do any1 have MCITP dumps??

Regards,

Sushant

@ venkat

Post hte job code here

Regards,

Sushant

Okk..

Why just the last log has to be restored? Not the logs before that??

Assume, i have a full backup nightly and have transaction logs every 15 during day time.

Then, if...

@ ashish

What is the use of copying backups to a safe place when already my log shipping is in place.

If some disaster happens to my production server, then can't I...

@ msn

If the subfolders option is selected, then you have to mention that individual folder in the maintenece clean up task.

Did you do that?

Regards,

Sushant

@ msn

This is the biggest drawback of maintenance plans. It happens many times.

check whether the sql agent has access to that backup directory?

Also, look out for Maintenance plan logs or...

@ sam

The Maintenance Plan Wizard can't determine which indexes need to be rebuilt, and which ones don't need to be rebuilt, and therefore has to rebuild them all.

Also,

Maintenance Plans created...

@ sam

Th drawbacks in maintenance plan in 2005 , I feel is the maintenance cleanup task.

It works randomly, sometimes it deletes my old backups regularly(acc to schedule), but sometimes...

@ sam

What version of sql server are you using?

Regards,

Sushant

@jeffrey

I should start profiler and trace on login event on VM or on the Production server?

I saw a job on prod server that runs every minute, but i checked the...