SQL Server 6.5 was having pagelevel locking but SQL Server 7.0 onwards sql server is having rowlevel locking. This locking is dynamic and depend on Isolation level you are using...

As far as I know only DBCC INDEXDEFRAG utility is available for defrag of Indexes which is used for both cluster & non-cluster indexes in SQL Server 2000.

It won't work. While failover occurs at that time tempdb is on node1 d:\Tempdb folder. But Tempdb on node2 will be created only when you will restart the sql server....

Sysadmin can perform any activity in the sql server installation hence it's not possible.

In the cluster environment you can't put tempdb on the local drive. If you will put the tempdb on local drive of node1 when the failover happen tempdb location on...

Execute the following command which will give you idea about your database files. Execute the query with the respective database to find the related files.

select name, filename from sysfiles

Hope this...

Use following link to download Express Edition of sql server 2005.

http://msdn2.microsoft.com/hi-in/express/bb410791(en-us).aspx

In addition to all posted Reply...

Looks SAP/VLDB Database is very important to the Organisation. Hence you need to chalkout DR (Disster Recovery) Plan on the priority.

Log shipping would be ideal...