My first question is: Why are you using date as string/varchar?

SELECT LEN('HOW LONG IS THIS DATA?')

RESULT = 22...

what you looking for?

No, changing the autogrowth will result in your db growing by 1 gb everytime it goes over its size, althought the space needed might be 1mb? You'll reserver space for...

We had a similar issue on ESX, with a shared virtual disk, Server picked it up, but SQL refused.

Hope someone can clear this issue up?

try using

, instead of

:

Data Source=servername;Initial Catalog=dbname;

or try: http://www.connectionstrings.com

Anything below 300 is a cause for concern for PLE.

What is the BCHR on the node when failover occurs? less than 99% ?

Best practice suggests you install your engine, agent etc on a different drive, your MDF's on its own drive and your LDF's on its own drive.

never install your SQL Engine...

To make it all nice and pretty, yet functional, build a website, with different connection strings to each server, which tie in with DMV queries, and have them post the...

Similar issues:

http://www.sqlservercentral.com/Forums/Topic672649-391-1.aspx

http://www.sqlservercentral.com/Forums/Topic715463-146-1.aspx

I believe you will get the answers from those posts.

Good luck!

I think it's quite self explaining - get the database Online before trying a Backup through SSMS.

Sounds like you are trying to administer a pre- SQL 7.0 database and its objects.

Did you upgrade from 6.5 to 7, or 7 to 2000?

Personally, I want to say yes, but it depends on where you want to go with SQL development, maybe into BI? then, YES.

Also depends on the needs of te current...

I'll "trust" you rather and not suggest any changes.

Any extra knowledge is always a bonus, and learning .NET will increase your chances of understanding how applications use SQL as a back-end.

I have seen many job requirements for SQL...

This is a free dashboard tool from Idera that I could recommend:

http://www.idera.com/Products/Free-Tools/SQL-check/

no licensing involved, but it is limited, try it.