I think this policy need to be set at the windows level for the SQL server service account.

From SQL perspective, for the service account require Lock pages in memory windwos...

Hi DBADave,

Yes you can configure the MSDTC any time and add it as as clustered resources. You will have two options in that case.

1. Create a seperate MSDTC group, Inside...

i think during the failover all the sevices which was online in the first node, cluster service will try make online in the second node. hence it comes online.

If it...

check if this helps

alter database DATABASENAME set offline with rollback immediate

drop database DATABASENAME

The best idea would be doing a selective reindexing, means rather than doing all tables in the database for reindex select only those tables which are fragmented for re...

normally, MSDTC service will be running in one node and the dependend disk resource (shared SAN drive) will be online in the same node.

In the passive node DTC service &...

Hi,

I haven;t heard of this before in sql server.

I think upd_stats would be the name of some utility which might be doing something in the db (just a guessing)

Also check in the server (where the sql instance is running) event viwer (security) what kind of error your are getting while you try to connect. I am sure you...

if you are getting 'NT AUTHORITY\ANONYMOUS LOGON'. error from your desktop some time (not always) - it will not be a network issue. If it is a network issue it...

There is an interesting document related to NOLOCK and READUNCOMMITED. which talks about reading row more than once and missing of rows

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/11/10/1280.aspx

really helpfull to understad....thanks to TONY

I mean "SQL Server 2005 Mirroring " feature.

Assume you have two servers PRIMARY and SECONDARY

configure the mirroring between PRIMARY server to SECONDARY server, so you will have a mirrored database...

you may use mirroring for the DR purpose and then take a snapshot of the mirrored database for read only purpose

yes it is defenitly possible. And it is always a good idea to run the reporting instance in the passive node as it will solve the n/w issues for replication...

If you wanted to migrate only the user databases, just take a backup of those databases and restore it in the SQL 2000 server.

THANKS TO ALL.....good info