SMS Backup/ Restores

This page details problems and issues relating to backing up and restoring SMS.

Backing Up SMS 2.0 with ArcServe [23/8/02]
Can I Backup My Site Server and Restore it to a New Box? [25/10/00]
Existing Clients from Crashed Site Fail to be Installed on New Site [20/6/03]
How Are Other People Backing up their SMS Servers? [25/1/01]
How Do I Backup My SMS Site Server? [6/5/02]
Multiple instances of MMC.EXE left behind by nightly SMS backup tasks [9/11/00]
No Status Messages displayed in the Admin console for the SMS_SITE_BACKUP task [10/11/00]
SQL reports a 'Table Corrupt' error when running DBCCs [27/1/01]
Tlist.exe Hogging 100% of the CPU on Site Server [24/02/04]

Backing Up SMS 2.0 with ArcServe

Contributed By: Cliff Hobbs [MVP SMS]
ArcServe seems to to be one of the most popular backup programs out their 'in the wild' and here we give you some advice on using it to backup your SMS Site Servers ... [Go to article]

Can I Backup My Site Server and Restore it to a New Box?

Wondering if you can swap out your SMS Central Site Server by simply backing it up and restoring the data to the new hardware?.. [Go to article]

Existing Clients from Crashed Site Fail to be Installed on New Site

From the microsoft.public.sms.misc newsgroup
So your original Site Server crashed and you’re unable to restore the database. So you’ve installed SMS on a new server with a new database but now you’re finding that only newly installed clients are managed by the new server… [Go to article]

How Are Other People Backing up their SMS Servers?

If you're wondering how other people are backing up their SMS Servers then here's how... [Go to article]

How Do I Backup My SMS Site Server?

Contributed By: Cliff Hobbs [MVP SMS]
One of the BIG FAQS relating to SMS is how do you backup your SMS Site Server? Well let us explain... [Go to article]

Multiple instances of MMC.EXE left behind by nightly SMS backup tasks

Seeing multiple instances of MMC.EXE in Task Manager? Here's some information from Microsoft... [Go to article]

No Status Messages displayed in the Admin console for the SMS_SITE_BACKUP task

I'm using the SMS Backup Task. Until now I've always looked at the 'SMSBKUP.LOG' to search for the word 'error' and quickly scanned through it looking for anything untoward. However, towards the end of the file are various status messages with the codes 5009, 5011, 5013 etc.

The confusing thing is, when I look under 'Site Status | Site Code | Component Status' and look at the 'SMS_SITE_BACKUP' task in the MMC, no messages are shown, even though it shows the right date/time for the 'Last Started' and 'Last Message'?

This is a known issue and one Microsoft have not committed to fixing. To see the status messages for this task goto 'System Status | Status Message Queries'. Select 'All Status Messages from a Specific Component at a Specific Site'. Select 'SMS_SITE_BACKUP' as the component, select the Machine and Time and then run the query to display the status messages.

SQL reports a 'Table Corrupt' error when running DBCCs

I get the following message when I run the DBBB checkcatalog(SMS) command:

Server: Msg 2513, Level 16, State 15, Line 1
Table Corrupt: Object ID 322100188 (object 'Summarizer_ComponentTallys') does not match between 'SYSREFERENCES' and 'SYSCOLUMNS.'.
DBCC results for 'SMS'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Don't worry this is documented in Knowledge Base article 242953 'SMS: "Table Corrupt" When Running DBCC Checkcatalog Against SMS Database'.

Tlist.exe Hogging 100% of the CPU on Site Server

Contributed By: Heine Jeppesen
If you notice that tlist.exe is hogging the CPU on your Site Server this is a known issue and here’s a workaround... [Go to article]