Viewing 8 posts - 1,171 through 1,179 (of 1,179 total)
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...
January 9, 2008 at 10:21 pm
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.
January 9, 2008 at 10:01 pm
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....
January 9, 2008 at 5:38 am
Sysadmin can perform any activity in the sql server installation hence it's not possible.
January 9, 2008 at 5:31 am
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...
January 9, 2008 at 5:17 am
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...
January 8, 2008 at 5:10 am
Use following link to download Express Edition of sql server 2005.
http://msdn2.microsoft.com/hi-in/express/bb410791(en-us).aspx
January 8, 2008 at 5:01 am
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...
October 10, 2007 at 12:35 am
Viewing 8 posts - 1,171 through 1,179 (of 1,179 total)