Markus (3/27/2009)

---

Tuning indexes: Last Thursday night we had an outage that I rebuilt ALL of the indexes and did a 100% update stats as well. I typically rebuild...

Heh should pay more attention to your signature LOL. Thank-you!

Mohit.

Heh this looks very much like a server I finished fixing recently LOL. But I see you are checking _Total; it is not a good idea to do that...

Okay few more questions:

1) what do you mean by 3407,...

Thanks guys ;-).

Urg yaa 6.5 is nightmare but I have to support 2 Production and 1 Dev/Test install of 6.5. Heh you can backup directly to file in 6.5...

Blog Address: http://sqllearnings.blogspot.com (Primary), http://sqllearningsdmvdmf.blogspot.com (DMV/DMF Only)

I just started the FAQ section so it's still small ;-). What is your Blog link I'll added it to me Ref list...

As Lee said you really have to look at other counters; to get indication of throughput. He also made a good note those look scary but you have to...

Robert Davis (3/30/2009)

---

No, technically it is not offline, but that is the error that the maintenance plan's job used to return when it tried to backup the restoring database.

Based on...

Grant/Steve,

Going to pop another question about backups that I am curious about; I always have done backups directly to file using BACKUP DATABASE DBNAME TO DISK =...

Services are running? No issue in SQL Server starting up? Check the SQL Server Management logs to see what port it is on; since you have SQL 2000...

Hmmm I heard they changed it in one of the SP; but my backups been working successfully. I'll get back to you on that...

But I will note databases as...

How much memory does your server have? What OS are you running on? And what is your SQL Server's Min/Max memory setting right now?

Mohit.

Hi Venu,

Two reasons your backups might not be deleting ...

1) you are running SQL Server 2005 version which had a glitch in the "Maintenance Cleanup" task.

2) Your backup...

Please check ..

1) Some protocol is enabled on remote server TCP/IP or Named Pipes.

2) Remote Connection is enabled.

3) No firewall blockage between remote location and your computer.

Thanks.

I just wrote a script; tested in 2008 so should work in 2005 also.

Ref: http://sqllearnings.blogspot.com/2009/03/get-listing-of-databases-user-has.html

I think that's what you are looking for?

Thanks.