Manage remote instances using SQL Server 2005 tools

I'm trying to manage remote instances using the following SQL Server 2005 tools:

SQL Server Configuration Manager (SSCM)

SQL Server Surface Area Configuration (SSSAC)

It seems that SSSAC is designed to manage remote instances since it has the "change computer" link. On the other hand, SSCM does not have such link or something similar. I read this MS article http://msdn2.microsoft.com/en-US/library/ms190622.aspx so it seems that this is a way to run SSCM to manage remote instance. I was having problem to show SQL Server 2005 Services by following that article. However, the problem is now gone (don't know why yet).

What are the reasons that the SSCM is not designed to manage remote instances but SSSAC is? If SSCM is really designed not to manage remote instances, what is the purpose of having the word (Local) next to the SQL Server Configuration Manager?

If I understand correctly, the only main difference between SSCM and SSSAC is that SSCM does not have the functionality to turn on and off features according to http://www.microsoft.com/technet/prodtechnol/sql/2005/mgsqlexpwssmse.mspx

So, if I don't need to turn on and off features, SSCM will be the only tool needed if it can manage remote instance.

With SQL Server Management Studio (SSMS) open and Registered Servers visible, right-click a remote reristered server and click SQL Server Configuration Manager. You will see SQL Server Configuration Manager(remote server name).|||

Hi lkh,

Thanks for the information. I wonder why MS does not implement the change computer in SSCM. Is there a way to run SSSAC in SSMS?

|||

it is a command prompt utility see it can be run in Query Editor in sqlcmd mode

See SQL Server 2005 Books Online topic:

sac Utility

http://msdn2.microsoft.com/en-us/library/ms162800.aspx

you can add in in SSMS under Tools\External Tools. Its located at C:\Program Files\Microsoft SQL Server\90\Shared\SqlSAC.exe

Maintenance Plan/Backup Question

I'm having a problem on a remote server with what I think is a Maintenance
Plan that seems to be doing an endless backup. My db is about 3GB, the
backup file (.bak) of the database keeps growing and eventually will exceed
the amount of disk available. There is over 30GB of available space for
backups.
I've resorted at last to performing a manual backup and deleting all
Maintenance Plans from the database. The manual backup is approximately
2.1GB.
After 24 hours, the automated backup is still growing. On the database
properties page, the date/time for the last database backup keeps being
updated about every two hours.
Is it possible that backup operations are queued, and given time the
operations will cease on its own? Anyone have any suggestions on how to
stop the backup operation so that I can recreate a maintenance to automate
my database backups?
> I'm having a problem on a remote server with what I think is a Maintenance Plan that seems to be
> doing an endless backup. My db is about 3GB, the backup file (.bak) of the database keeps growing
Probably not maint wiz. Probably someone coded BACKUP DATABASE and forgot to do WITH INIT (NOINIT =
append is the default).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Don Delk" <delk@.intransit.dot.gov> wrote in message news:ePe%23IJ4vFHA.2164@.TK2MSFTNGP10.phx.gbl...
> I'm having a problem on a remote server with what I think is a Maintenance Plan that seems to be
> doing an endless backup. My db is about 3GB, the backup file (.bak) of the database keeps growing
> and eventually will exceed the amount of disk available. There is over 30GB of available space
> for backups.
> I've resorted at last to performing a manual backup and deleting all Maintenance Plans from the
> database. The manual backup is approximately 2.1GB.
> After 24 hours, the automated backup is still growing. On the database properties page, the
> date/time for the last database backup keeps being updated about every two hours.
> Is it possible that backup operations are queued, and given time the operations will cease on its
> own? Anyone have any suggestions on how to stop the backup operation so that I can recreate a
> maintenance to automate my database backups?
>
|||Hello,
I suggest that you check SQL server agent jobs. You may perform the
following steps to check which job perform a backup:
1. Double-click Management> SQL Server Agent > Jobs in SQL server
Enterprise Manager(SEM).
2. Locate the jobs in the right window.
3. Double-click the job. Check the steps and the schedules for the job to
see what job perform a backup every two hours.
4. Edit the job step.
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

Maintenance Plan/Backup Question

I'm having a problem on a remote server with what I think is a Maintenance
Plan that seems to be doing an endless backup. My db is about 3GB, the
backup file (.bak) of the database keeps growing and eventually will exceed
the amount of disk available. There is over 30GB of available space for
backups.
I've resorted at last to performing a manual backup and deleting all
Maintenance Plans from the database. The manual backup is approximately
2.1GB.
After 24 hours, the automated backup is still growing. On the database
properties page, the date/time for the last database backup keeps being
updated about every two hours.
Is it possible that backup operations are queued, and given time the
operations will cease on its own? Anyone have any suggestions on how to
stop the backup operation so that I can recreate a maintenance to automate
my database backups?> I'm having a problem on a remote server with what I think is a Maintenance Plan that seems to be
> doing an endless backup. My db is about 3GB, the backup file (.bak) of the database keeps growing
Probably not maint wiz. Probably someone coded BACKUP DATABASE and forgot to do WITH INIT (NOINIT =append is the default).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Don Delk" <delk@.intransit.dot.gov> wrote in message news:ePe%23IJ4vFHA.2164@.TK2MSFTNGP10.phx.gbl...
> I'm having a problem on a remote server with what I think is a Maintenance Plan that seems to be
> doing an endless backup. My db is about 3GB, the backup file (.bak) of the database keeps growing
> and eventually will exceed the amount of disk available. There is over 30GB of available space
> for backups.
> I've resorted at last to performing a manual backup and deleting all Maintenance Plans from the
> database. The manual backup is approximately 2.1GB.
> After 24 hours, the automated backup is still growing. On the database properties page, the
> date/time for the last database backup keeps being updated about every two hours.
> Is it possible that backup operations are queued, and given time the operations will cease on its
> own? Anyone have any suggestions on how to stop the backup operation so that I can recreate a
> maintenance to automate my database backups?
>|||Hello,
I suggest that you check SQL server agent jobs. You may perform the
following steps to check which job perform a backup:
1. Double-click Management> SQL Server Agent > Jobs in SQL server
Enterprise Manager(SEM).
2. Locate the jobs in the right window.
3. Double-click the job. Check the steps and the schedules for the job to
see what job perform a backup every two hours.
4. Edit the job step.
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Maintenance Plan/Backup Question

I'm having a problem on a remote server with what I think is a Maintenance
Plan that seems to be doing an endless backup. My db is about 3GB, the
backup file (.bak) of the database keeps growing and eventually will exceed
the amount of disk available. There is over 30GB of available space for
backups.
I've resorted at last to performing a manual backup and deleting all
Maintenance Plans from the database. The manual backup is approximately
2.1GB.
After 24 hours, the automated backup is still growing. On the database
properties page, the date/time for the last database backup keeps being
updated about every two hours.
Is it possible that backup operations are queued, and given time the
operations will cease on its own? Anyone have any suggestions on how to
stop the backup operation so that I can recreate a maintenance to automate
my database backups?> I'm having a problem on a remote server with what I think is a Maintenance Plan that seems
to be
> doing an endless backup. My db is about 3GB, the backup file (.bak) of the databa
se keeps growing
Probably not maint wiz. Probably someone coded BACKUP DATABASE and forgot to
do WITH INIT (NOINIT =
append is the default).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Don Delk" <delk@.intransit.dot.gov> wrote in message news:ePe%23IJ4vFHA.2164@.TK2MSFTNGP10.ph
x.gbl...
> I'm having a problem on a remote server with what I think is a Maintenance
Plan that seems to be
> doing an endless backup. My db is about 3GB, the backup file (.bak) of th
e database keeps growing
> and eventually will exceed the amount of disk available. There is over 30
GB of available space
> for backups.
> I've resorted at last to performing a manual backup and deleting all Maint
enance Plans from the
> database. The manual backup is approximately 2.1GB.
> After 24 hours, the automated backup is still growing. On the database pr
operties page, the
> date/time for the last database backup keeps being updated about every two
hours.
> Is it possible that backup operations are queued, and given time the opera
tions will cease on its
> own? Anyone have any suggestions on how to stop the backup operation so t
hat I can recreate a
> maintenance to automate my database backups?
>|||Hello,
I suggest that you check SQL server agent jobs. You may perform the
following steps to check which job perform a backup:
1. Double-click Management> SQL Server Agent > Jobs in SQL server
Enterprise Manager(SEM).
2. Locate the jobs in the right window.
3. Double-click the job. Check the steps and the schedules for the job to
see what job perform a backup every two hours.
4. Edit the job step.
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
========================================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.