The data drive is shared but is dedicated to the instance. The data drive is not shared between instances.

When a cluster fails over, you will witness a brief outage....

No hard feelings for Oracle guys. But I have seen this when people start managing SQL Server like Oracle. They need to understand that Life is easy with SQL Server.

If it is a default instance, youcan run sp_addserver 'servername' and register the server. for named instance, you will have to run sp_addserver 'servername\instance_name'

The reason microsoft prefers making changes in the Enterprise manager is that it does update the services on both nodes. If you do it through Services snap-in, you will have...

SQL server SP4 has more fixes and does not introduce any new features. With this said, i think you should be safe to go ahead and install SP4 but you...

Detaching a database is almost equivalent to dropping the database with the exception of the data/log files not getting deleted. the entry in sysdatabases for the database name gets lost...

You might still want to check the option for automatically growth. Say if you are updating a table with 1 million rows, as steve mentioned, the transaction does get written to...

You can recycle the logs periodically by using sp_cycle_errorlog. But as Steve said, there is no way to restrict them to a certain size.

WHERE

 DATEADD(ss,-14400,PO_DATE) >=  '01/01/2005'

AND

 DATEADD(ss,-14400,PO_DATE) <= '01/02/2005'

GROUP BY

With what i understand, the conditions above won't filter any dates. You can just get rid of the conditions above.

Is this what you are looking for ?

select suser_sname(a.sid), 'Type '= case when a.isntgroup = 1 THEN 'Win Group'

    else 'User'

     END

, c.name from sysusers a join sysmembers b on a.uid...

You won't see an entry of 127.0.0.1 :1433 on clusters. I think this is a loopback entry and wont' be there on clusters. some thoughts.

1) Can you try opening  a...

Below are some articles.

http://www.databasejournal.com/features/mssql/article.php/10894_2244381_3

http://database.ittoolbox.com/browse.asp?c=DBPeerPublishing&r=http%3A%2F%2Fhosteddocs%2Eittoolbox%2Ecom%2FMicrosoft%2DSiebel091704b%2Epdf

FYI- I did like the article from Andrew. I would say that i do remember one scenario where our SAN team gave up(as usual) and...

To move the log to a different location, detach the database, copy the file to your destination and attach the file stating the new location.

Below are a couple of links

http://vyaskn.tripod.com/moving_sql_server.htm

http://www.databasejournal.com/features/mssql/article.php/1479841

You can write a small script by using the cluster command to find out on what resource your cluster is running and schedule the same.

e.g.

cluster /cluster:server_name group "disk group 1"...