Can''t configure Features on Clustered Server

Hi, I am a relative newbie to SQL Server and I need some help trying to configure an existing clustered server. Using surface area configuration with "local" checked, I can see all of the components as pictured here. However, checking one (i.e. DatabaseMail) results in a pop-up message with "You cannot configure surface area of clustered services by connecting to a computer name. Connect to the virtual server to configure clustered services".

Ok. Fair enough. I then go back, check "remote" and enter the name of the cluster. After connecting, it only shows me a partial list of services as pictured here.

I first encounterd this while trying to enable Databasemail. However, I need to get an understanding of what I need to do be able to configure services or features on a clustered server using SAC.

Thanks for any help.

Just wondering if anyone else has had a similar problem and how they solved it.

I've inherited this problem and still have not found a resolution. Any response would be appreciated.

Can''t configure Features on Clustered Server

Hi, I am a relative newbie to SQL Server and I need some help trying to configure an existing clustered server. Using surface area configuration with "local" checked, I can see all of the components as pictured here. However, checking one (i.e. DatabaseMail) results in a pop-up message with "You cannot configure surface area of clustered services by connecting to a computer name. Connect to the virtual server to configure clustered services".

Ok. Fair enough. I then go back, check "remote" and enter the name of the cluster. After connecting, it only shows me a partial list of services as pictured here.

I first encounterd this while trying to enable Databasemail. However, I need to get an understanding of what I need to do be able to configure services or features on a clustered server using SAC.

Thanks for any help.

Just wondering if anyone else has had a similar problem and how they solved it.

I've inherited this problem and still have not found a resolution. Any response would be appreciated.

sql

Cannot truncate transaction log.

DB Newbie question ahead.

I have a mere 100MB db with a 4GB transaction log. I want to truncate the log as I understand that truncating it will shrink the log by removing the transactions that have already taken place. However, the option to do a transaction backup is greyed out. I suspect this is from the db being in transactional replication with another server; however, I don't know for sure.

Are there any other ways that I can shrink the transaction log? I would like to do shrink it without taking the db offline either.I think the recovery model was set to simple, that's why you can't take log backup. You can use DBCC Shrinkfile to shrink your log file to the size you want.|||Are you using SQL 2000?
If so you can do that by the following

- Go to DB properties and change the backup type to FULL
- Take a backup of the database and keep it safe.
- Go to DB properties again change the backup type to SIMPLE
- Go to all tasks and Shrink the file
- Go to DB properties again and change the backup type to FULL again so that it logs everything.|||Yes, I am using SQL2000. That's important information ;)
SQL2000 on win2003.

smasanam: I tried that and it didn't shrink the log file. Still 4.5GB.

Is the log file important for transactional replication? This db is replicated nightly to another server. If everything is updated and fully bkup'd would the log file be necessary? Or could I just delete it?

Thanks for the help.