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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
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.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
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....
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 9, 2008 at 5:38 am
Sysadmin can perform any activity in the sql server installation hence it's not possible.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
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
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 10, 2007 at 12:35 am
Viewing 8 posts - 1,171 through 1,179 (of 1,179 total)