Have you double checked your NIC settings and Switch port settings ?

Some NICs and Switches need 'auto' and others need a 'fixed' transfer rate set. Your hardware and Switch vendors...

The solution is:

1) not to use maintenance plans

2) add FULLSCAN

3) write a better script (Hint: there are lots out in SSC)

Some best practices:

1) do not try to defragment heaps

2) do...

for the world culturally deficient could reanslate 4.5 lac into USD please ...

At present we have separate AD accounts for services on 'logical' groups of servers. These AD service account passwords are changed annually or when staff changes. We are moving further...

Here is what we have setup on demand on key servers as a 'default':

General State Counters

======================

Memory - Available MBytes

Memory – Pages/sec

Network Interface – Bytes total/sec

Physical Disk - %...

why not try using the insert/exec construct to store the results of your xp_cmdshell output in a temp table, delete the nulls and use selects to check your results.

Agreed that it does work (we tested the same in a lab environment back in 2006).

The important thing to remember though is that if you have a production issue with...

It look like you have a valid backup file.

Try this command and post the results please ...

RESTORE DATABASE [Testing]

FROM DISK = N'D:\SQLBackups\wsgis20090906.bak'

WITH

MOVE N'WSGIS' TO N'G:\SQLDBFiles\Testing.mdf',

MOVE N'WSGIS_log' TO N'G:\SQLDBFiles\Testing_log.ldf', STATS...

execute this script in a query window:

RESTORE FILELISTONLY

FROM DISK = N'D:\SQLBackups\wsgis20090906.bak'

post the results of the query please.

hmmm ... could it be that these are Maintenance Plans ?

Rule #33 ?

I am curious what the list of rule you have is ?

Would you mind sharing ?

Thank you as well !

What was the resolution to your situation ?

Please advise so all can learn from your experience ...

back on point - if I was not a DBA I'd be:

Cabinet/Furniture maker

Landscaper/Master Gardener

Construction equipment operator (Operating Engineer)

Please notice that not one of these professions is related to IT directly.

However,...

Try performing the restore filelistonly and verify from a query window and post the messages.