MSDE sharepoint databases how to import and export

Dear all,
I have a Intranet running the sharepoint version which
comes with Frontapage 2002 and MS desktop SQL 7.
My server have a problem and I have to upgrade it to MS
desktop SQL 2000A. Now my sharepoint databases don't work
anymore.
I was wondering if theere is a way to import them back
into the new MS DESKTOP SQL 2000A.
Thank you for any help
HI Renato,
ReadmeMSDE2000A.htm comes with your download of MS Desktop SQL 2000A. It
talks about the changes in this release. Your database doesn't work any
more probably due to the security change that requires strong password.
Empty sa passowrd is no longer accepted. If that is the case, you can
change your sa password by running this query: EXEC sp_password NULL,
'yourpassword', 'sa' and then replace in your code with the new password.
Hope this helps.
Amy
| Content-Class: urn:content-classes:message
| From: "Renato" <anonymous@.discussions.microsoft.com>
| Sender: "Renato" <anonymous@.discussions.microsoft.com>
| Subject: MSDE sharepoint databases how to import and export
| Date: Wed, 7 Apr 2004 07:34:13 -0700
| Lines: 13
| Message-ID: <19b6f01c41cad$65a1d0c0$a101280a@.phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcQcrWWh/rvselubSzuv0Twjq4q0CQ==
| Newsgroups: microsoft.public.sqlserver.msde
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.msde:13479
| NNTP-Posting-Host: tk2msftngxa09.phx.gbl 10.40.1.161
| X-Tomcat-NG: microsoft.public.sqlserver.msde
|
| Dear all,
|
| I have a Intranet running the sharepoint version which
| comes with Frontapage 2002 and MS desktop SQL 7.
|
| My server have a problem and I have to upgrade it to MS
| desktop SQL 2000A. Now my sharepoint databases don't work
| anymore.
|
| I was wondering if theere is a way to import them back
| into the new MS DESKTOP SQL 2000A.
|
| Thank you for any help
|