RE: Problems with upgrade to WSS 3.0

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fswiss\fprq2\fcharset0 Verdana;}}
\viewkind4\uc1\pard\f0\fs20 Hi I. Kinal,
\par
\par As I know, there is no different on restoring a database (which is backed up from SQL Server 2000 Desktop Engine) to SQL Server 2005 Express Edition compared to SQL Server 2000 Desktop Engine. You can just refer to the following articles to back up and restore the database from MSDN to SQL Server Express:
\par
\par BACKUP (Transact-SQL)
\par http://msdn2.microsoft.com/en-us/library/ms186865.aspx
\par
\par RESTORE (Transact-SQL)
\par http://msdn2.microsoft.com/en-us/library/ms186858.aspx
\par
\par During the restore process, the upgrade of the database is also performed.
\par
\par In the meantime, I am so sorry for the wrong link provided in my previous response. Here is the correct link for your reference.
\par
\par Install Windows SharePoint Services 3.0 on a stand-alone computer
\par http://technet2.microsoft.com/Office/en-us/library/6181fe5b-90ca-40cf-aade-abd59cf3c9071033.mspx
\par
\par Please try the steps on the article to install WSS 3.0 and then check the result. Also, it is recommended that you have a copy of database in case any potential risks.
\par
\par Hope this helps!
\par
\par If anything is unclear, please let me know. I am standing by for your reply.
\par
\par Regards,
\par
\par Ada Pan
\par
\par Microsoft Online Partner Support
\par Get Secure! - www.microsoft.com/security
\par ====================================================
\par When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue.
\par ====================================================
\par This posting is provided "AS IS" with no warranties, and confers no rights.
\par
\par
\par }

Relevant Pages

  • RE: Big queries
    ... One can “compact” a SQL Server database by using the SQL Server Enterprise ... Manager console or Transact-SQL to manipulate database settings. ... dialog window or to automatically shrink the database using the ... If you are wondering if the Transact-SQL can be run from within Access, ...
    (microsoft.public.access.queries)
  • Re: Backing up related databases
    ... Have you considered using the following Transact-SQL command: ... You can use it to backup your entire database. ... your database) within SQL Server Books Online (look in the SQL Server ...
    (microsoft.public.sqlserver.tools)
  • Setting the default content database
    ... I tried restore a content database to a different stand alone WSS 3.0 ... It looks like I changed the server names successfully during ... the restore process and the database appears under "content databases" ... How do I tell SharePoint Services to look at this new ...
    (microsoft.public.sharepoint.windowsservices)
  • Opinions on procedural language being introduced into SQL Server 2005
    ... I'd especially like to hear what Joe Celko thinks of this. ... "Many tasks that were awkward or difficult to perform in Transact-SQL ... So two of the three tiers will now be accomplished on the database ...
    (microsoft.public.sqlserver.programming)
  • User permissions
    ... Is there a transact-sql or other way that I can use to ... grant permissions to all objects in a database to a ... Enterprise Manager. ...
    (microsoft.public.sqlserver.security)