If you do not have a policy of log backups, then it is advisable to sqitch to simple recovery model. This would not need any sort of log maintenance from...

Use the following to determine if the sql server is a clustered one.

Select serverproperty( 'IsClustered')

To fine out the instance which is the current of cluster resources run:

Select serverproperty( 'ComputerNamePhysicalNetBIOS" )

To...

Hey, please let me know if you were able to find a solution for this one.

My thought would have been to take it out of the cluster and then rebuild...

You should not be attempting to truncate any of the tables mentioned below.

Do you have an alert server setup with the primary and secondary.

User the query below on your primary...

I am not sure whether it is obvious, but you would need to setup a windows cluster before you can go on to a sql 2005 cluster.

Vmware Server is a...

Are you guys trying to run the Standard Report from the sql server dashboard or is it some other report?

To make things easier user the query below for primary

use msdb

select...

Check this link : http://msdn.microsoft.com/en-us/library/aa275464(SQL.80).aspx

You can set the database to single user mode, whcih will lock the database for other users. Only one connection can be made to...

You first need to check the error log file for sql server which contains the logs of all errors.

It is located at %programfiles%\Microsoft SQL Server\100\Setup Bootstrap\Log\ and will have detailed...

Thanks Jason, but do you think a fiailover will not happen if the option of "Affect the group" is not checked for that specific resource.

This is under resource properties under...

The answer is not straight forward. To be able to get to a optimized log file size, you would need to monitor it growth over a period of few days,...

The first thing you need to do is check whether log is being backed up through jobs or not. If they are not, you immediately need to take a log...

Thanks guys. I got my answer. I just wanted to avoid a restart since I believe that the server will handle the application connectivity during that time of 5-10 sec...

Thanks for reply guys.

Kalyani's reply sorted it out. I am somewhat familiar with log management and backup em up 15 min. The problem arose due to heavy log generation...

Thanks for your reply. that helps regarding the strategy, but I am still unable to ascertain whether reorganizing a clustered index also reorganizes the non clustered indexes on the same...

you can also go with

select * from sys.database_files - for specific files of db

select * from sys.masterfiles - details of all files