RE: Sharepoint Backup & Restore



Hi Matt,

Thanks for using the SBS newsgroup.

>From your description, I understand the issue to be: the backup file is
automatically saved in C: drive and is lack of space of the C: drive. If I
am off base, please don't hesitate to let me know.

The restore site database STS_RESTORE should be saved in the location of
the SQL instance installed. Such as C:\Program Files\Microsoft SQL
Server\MSSQL$SHAREPOINT\Data. So the STS_RESTORE is created in the C drive
even you have moved the Sharepoint database to another location. You can
also move the database to other partition as the method to move sharepoint
database.

Additionally I would like to give some suggestions to free up the main
drive:

1. Use the Disk Cleanup tool to delete all temporary files. You can launch
the tool from Start -> Programs -> Accessories -> System Tools -> Disk
Cleanup. For more information, you can refer to the following KB article
which also applies to Windows 2000/Windows 2003:

310312 Description of the Disk Cleanup Tool in Windows XP
http://support.microsoft.com/?id=310312

2. You can delete the $NtUninstallxxxxxx$ folder to free up space. When we
install a Windows Update or Hot Fix, a folder named $NtUninstallxxxxxx$
will be created under the WINNT folder. When we install Service Pack, a
folder named $NTServicePackUninstall$ will also be created. These folders
contain the uninstallation files for these Windows Updates and service
pack. They keep the original version of the files replaced by the updates
and service pack. With these folders, we can uninstall the updates and
service pack in case some cause problems to the system. If your system runs
well, you can safely remove the folders.

For more information, see:

290402 HOW TO: Remove the Service Pack Restore Files and Folders in Windows
http://support.microsoft.com/?id=290402

3. Perform an online backup of the Exchange 2003 Information Store to purge
the transaction log files. You can use either the Windows 2003 built-in
NTBackup tool or an Exchange-aware third party backup tool. To use NTBackup
to backup Exchange information store, you can refer to the following
Microsoft KB article:

258243 How to Back Up and Restore an Exchange Computer by Using the Windows
http://support.microsoft.com/?id=258243

4. Use the "Eseutil /d" command to defrag the Exchange 2003 server
databases. When the users delete messages, the size of the database will
keep the same and you must perform an offline defragmentation using the
exeutil tool to reduce the Exchange database seize. Please note that
defragmenting a database requires free disk space equal to 110 percent of
the size of the database that you want to process so if you do not have
enough free space to run the eseutil tool, you can defrag the database on
another computer. See:

328804 How to Defragment Exchange Databases
http://support.microsoft.com/?id=328804

192185 XADM: How to Defragment with the Eseutil Utility (Eseutil.exe)
http://support.microsoft.com/?id=192185

5. You can consider moving the Exchange databases and log files to another
hard drive with bigger capacity. You can refer to the following MS KB
articles to get more information on doing this:

821915 How to move Exchange databases and logs in Exchange Server 2003
http://support.microsoft.com/?id=821915

6. You can also move client programs folder, sharepoint database, monitor
database, and so on to another location to free up the disk space.

You can refer to the following MS white paper to move data folders as you
want to:
Moving Data Folders for Windows Small Business Server 2003
http://www.microsoft.com/technet/prodtechnol/sbs/2003/maintain/movedata.mspx

830254 How to move the client programs folder to another location in Windows
http://support.microsoft.com/?id=830254

Hope above information help! I am happy to be of assistance to you and look
forward to your reply.

Have a nice day!

Sincerely,

Jenny Wu
Microsoft CSS Online Newsgroup Support
Get Secure! - www.microsoft.com/security
======================================================
This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx

When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.

Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.

For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.

Any input or comments in this thread are highly appreciated.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
>From: "Matt S" <mattstrain@xxxxxxxxxxx>
>Newsgroups: microsoft.public.windows.server.sbs
>Subject: Sharepoint Backup & Restore
>Date: 12 Jan 2006 12:20:26 -0800
>Organization: http://groups.google.com
>Lines: 24
>Message-ID: <1137097226.283293.59840@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>
>NNTP-Posting-Host: 62.173.120.235
>Mime-Version: 1.0
>Content-Type: text/plain; charset="iso-8859-1"
>X-Trace: posting.google.com 1137097231 24378 127.0.0.1 (12 Jan 2006
20:20:31 GMT)
>X-Complaints-To: groups-abuse@xxxxxxxxxx
>NNTP-Posting-Date: Thu, 12 Jan 2006 20:20:31 +0000 (UTC)
>User-Agent: G2/0.2
>X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1;
..NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
>Complaints-To: groups-abuse@xxxxxxxxxx
>Injection-Info: g14g2000cwa.googlegroups.com; posting-host=62.173.120.235;
> posting-account=_hkGSA0AAADAlk-MeBVy5NlfvK9kbuLO
>Path:
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onli
ne.de!border2.nntp.dca.giganews.com!nntp.giganews.com!news-out.readnews.com!
news-xxxfer.readnews.com!postnews.google.com!g14g2000cwa.googlegroups.com!no
t-for-mail
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.windows.server.sbs:236183
>X-Tomcat-NG: microsoft.public.windows.server.sbs
>
>Today i had to move our sharepoint DB to our D drive as C was getting
>full.
>
>This has all been completed and works fine.
>
>However I still have the following problem:
>
>As well as using backup software for tape backup I also have scheduled
>tasks to run a backup of the sharepoint DB using Stsadm.exe after
>followng these guidlines:
>
>http://www.microsoft.com/smallbusiness/support/articles/backup_restore_sbs2
003.mspx#ECAA
>
>However i have attempted a test of restoring a site however as my C
>drive does not have enough space (only 2GB left) it fails.
>
>This is becuase during restoration it creates a STS_RESTORE DB which
>automatically goes onto the c drive and as this is 1GB in size and the
>tempDB file reaches 1GB in size during the operation i run out of
>space.
>
>What I am trying to ask in a long winded way is how do i get it to
>create the STS_RESTORE DB on my D drive?
>
>

.



Relevant Pages

  • RE: Windows server 2003 SP1
    ... Open Exchange System Manager ... check "the database can be overwritten..." ... Do the same for the public folder store ...
    (microsoft.public.windows.server.sbs)
  • Re: Have database mismatch, can I move NTDS.dit and Exchange to new identical server?
    ... Check the physical location of the Winnt\NTDS\ folder. ... Check the permissions on the \Winnt\NTDS folder. ... as it may not be the database that is the ... MCSA + Exchange ...
    (microsoft.public.win2000.active_directory)
  • Re: cant mount information store
    ... then moved the E00.log file into a different folder and both databases ... I then reinstalled exchange and then installed exchange 2003> sp2. ... > error -1216 because it encountered references to a database, ... > Information Store First Storage Group: ...
    (microsoft.public.windows.server.sbs)
  • RE: Error 474 in Event Viewer
    ... What service pack level are you at for Exchange? ... Move the database to a different partition ... Test the backup again. ... I just cannot backup the emails. ...
    (microsoft.public.windows.server.sbs)
  • Re: Backup of Exchange Server
    ... Unfortunatily i don't have any good online backup. ... > Scanmail ---> Exchange ... > MicrosoftExchange Server Database Utilities ... Streaming File: d:\tempdfg.STM ...
    (microsoft.public.exchange.admin)