Thanks for the solutions!!!!!

0 views
Skip to first unread message

Kevin S. Smith

unread,
May 23, 2002, 9:41:01 AM5/23/02
to
Thank you for your solutions. It is working out perfectly.


TonyB

unread,
May 23, 2002, 11:04:18 AM5/23/02
to
Kevin,

I take it by your post you were able to properly backup your MSDE database
and SPTS web site to a tape drive or some other form of backup media.

I got the automated backup to work per Ralph Wimmer's instructions (Thanks
Ralph!). When you performed the XCOPY of the web site, did you have a
routine (batch file) stop IIS, perform the XCOPY, then restart IIS? If so,
or if not, could you post detailed steps?

I still consider myself very "green" when it comes to IIS, SPTS and MSDE.

TonyB

"Kevin S. Smith" <SpamN...@EriePlating.com> wrote in message
news:uepsan7...@corp.supernews.com...

Lorna Timbah

unread,
May 24, 2002, 6:59:37 AM5/24/02
to
I'd like to see the detailed steps as well. If this can be put up in
sharepointtips.com would be cool too, so I don't have to search thru the
whole newsgroup.

Lorna
---

"TonyB" <tbeit...@cowanandassociates.com> wrote in message
news:ulio9rmACHA.2312@tkmsftngp02...

Ralph Wimmer

unread,
May 24, 2002, 1:44:14 PM5/24/02
to
Hi,
this was a long discussion with a short result about back up the MSDE
database by using SPTS HTML Administration pages.
Microsoft has published a article in MSDN but has forgotten to say
that you have to do first a manual backup where you
can enter the path for the backup file before you setup the automatic backup
which will use this path.
This was the problem!
You will find this discussion under "Backing up MSDE" in this newsgroup.

Following is a cutout of a article you will find here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmsipag/ht
ml/msi_pag_chapter8.asp


To back up a MSDE database by using HTML Administration pages:

On the taskbar of the server, click Start, point to Programs, point to
Administrative Tools, and then click Microsoft SharePoint Administrator.
On the Server Administration page, next to the virtual server that contains
the data that you want to back up, click Administration.
On the Virtual Server Administration page, click Backup and restore
database.
On the Backup and Restore Database page, in the Backup path and filename
box, type the path and file name to store the data in.
For example, C:\MSSQL7\BACKUP\Webname.bak.

Click Backup.
You can restore the database from the same Database Backup and Restore page.

To automatically back up the database:

On the taskbar of the server, click Start, point to Programs, point to
Administrative Tools, and then click Microsoft SharePoint Administrator.
On the Server Administration page, next to the virtual server that contains
the data that you want to back up, click Administration.
On the Virtual Server Administration page, click Schedule database backup.
Next to Automatic database backups are, select On.
Under Automatic database backups occur, select Daily, Weekly, or Monthly.
Do one of the following:
If you selected Daily, in the Time box, select the time of day to perform
the backup process.
If you selected Weekly, in the Time box, select the time of day, and then in
the Weekday box, select the day of the week to perform the backup process.
If you selected Monthly, in the Day box, select the day of the month, and
then in the Time box, select the time of the day to perform the backup
process.
Click Submit.

You also have to make a copy of the intranet folders at the same time!

I use no backup software on my SPTS server.
I make a copy to a different server which has a auto backup.
For this i use the build in sceduler of w2k with a simple batch job like
this:
XCOPY %source%\*.* %destination%\*.* /S /E /V /C /D /R /H /Y
You dont have to stop IIS to do this!

Wbr
Ralph Wimmer
Austria

"Lorna Timbah" <hate...@hotmail.com> schrieb im Newsbeitrag
news:u$AyFIxACHA.1840@tkmsftngp04...

TonyB

unread,
May 24, 2002, 1:56:08 PM5/24/02
to
Thanks Ralph! I think that's the answer Lorna and I were looking for.

TonyB

"Ralph Wimmer" <rwh...@aon.at> wrote in message
news:ezl8Dq0ACHA.2352@tkmsftngp02...

Reply all
Reply to author
Forward
0 new messages