• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 719
  • Last Modified:

HELP!!! Need to make a copy/backup of my WSS 3.0 database content.

HELP!!! I need to make a backup/copy of my WSS 3.0 database content, which is using the built-in database server (I believe SQL Server 2005 Express), on a Server 2003 R2 x32, so I can move (migrate) it to a test server that is running Server 2008 R2 & SQL Server 2005 x64 SP4 & SharePoint Foundation 2010 x64.

How can I make a backup copy of WSS 3.0 database content so I can then upgrade it to SPF2010?

-------------------------------------------------------------------------------------------------------------------------------------

Currently, by digging down to the directory where the database resides, I see the following:
(C:\WINDOWS\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data)


- SharePoint_AdminContent_d9c2............ .mdf                 32.1MB
- SharePoint_AdminContent_d9c2............ _log.LDF            313MB
- SharePoint_Config_bb9bb................        .mdf                  6.18MB
- SharePoint_Config_bb9bb................        _log.LDF             13.8GB
 
- WSS_Content.mdf                     1.29GB
- WSS_Content_log.LDF               15.2GB
- WSS_Search_Server1.mdf         146MB
- WSS_Search_Server1_log.LDF    1.27GB
-------------------------------------------------------------------------------------------------------------------------------------

Now, I have heard there is a Studio Management console for the SQL Server 2005 Express, but not sure if it is what I need to perform the backup the most efficient way.  Also, need to have little to no down time for the currently running WSS 3.0 services.

Lastly, I heard something about a 4GB limit or something with WSS 3.0.  I noticed that my WSS_Content_Log.LDF is over 15GB, how is this going to play into my backup scenario?

What do you recommend & how do I do it?

Let me know if I am missing information that is required to recommend a solution.

Thanks in advance.
0
rsnellman
Asked:
rsnellman
  • 7
  • 4
4 Solutions
 
Justin SmithSr. System EngineerCommented:
DB size restrictions have to do with SQL version only.  For SQL Express 2008 it's 4 GB, for Express 2008 R2, it's 10 GB.  You have huge log files as I'm assuming you never backup your log file.  I suggest you switch all databases to SIMPLE recovery model, wait an hour or so, and manually shrink the files down by running dbcc shrinkfile ('dbname_log', 500)....which should shrink them down to 500 MB.

You can backup your files up by using SQL Manager Express.  This is a free download from Microsoft, just do a search.  Just right click the db, tasks - backup
0
 
Justin SmithSr. System EngineerCommented:
You would then copy the backup to the new SQL server, and attach it through SQL Manager on that server.  Then proceed with the db attach upgrade in SharePoint.

Note, you must be on WSS 3.0 SP2 or later in order to upgrade.  Might run stsadm -o preupgradecheck on WSS before upgrading, which will show you any issues you might run into.
0
 
rsnellmanAuthor Commented:
So, I "should" download and install the SQL Express Studio Manager on the Server 2003 that is running WSS 3.0 and perform the backup of the current database?

Yes, as far as I can tell there has never been a backup that clears the log performed.

It is WSS 3.0 SP2 or SP3, not totally for sure, but do know it is at least SP2.

OK, since I know very little about SQL, how do I perform this "SIMPLE recovery model" on this database?

Thanks.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
rsnellmanAuthor Commented:
Will the installation of SQL Express Studio Manager require a restart of the server?

Need to know whether I will require to inform my end users of some brief down time.
0
 
Justin SmithSr. System EngineerCommented:
Put it on the server that SQL is running on.  No, it won't require a reboot.

If you right click on a database in SQL Manager and do Properties, if you look at the Options section you will see Recovery Model.  Change any that say FULL to SIMPLE.
0
 
rsnellmanAuthor Commented:
OK.  I have installed the SQL Server Management Studio Express, but cannot log into or connect to the database (server1\microsoft##ssee).

I receive the following error when attempting to connect to it.
Server name: server1\microsoft##ssee
Authentication: Windows Authentication
Username: administrator

Error
"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The serve was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server)


The WSS 3.0 is local database on the system drive of the server.

What am I doing wrong?  How can I connect to the WSS 3.0 database via MS SQL Server Management Studio Express?

Thanks again.
0
 
rsnellmanAuthor Commented:
OK, scratch my last obstacle questions.  I found the solution.  When dealing with WSS 3.0 databases with a default (local) installation you need to log in to the following database path:

\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
Windows Authentication

Worked like a charm.
0
 
rsnellmanAuthor Commented:
OK, so i am seeing the following databases.

System Databases
SharePoint_AdminContent_d9c2....
SharePoint_Config_bb9bbfba.....
WSS_Content
WSS_Search_Server1

Which database(s) do I need to backup and copy to the test server to practice upgrading WSS 3.0 to SharePoint Foundation 2010?
0
 
Justin SmithSr. System EngineerCommented:
Just wss content.
0
 
rsnellmanAuthor Commented:
OK.  Have it backed up and have copied it over to the test server (SharePoint Foundation 2010).

Thanks.
0
 
rsnellmanAuthor Commented:
Opps.  Forgot to change it to SIMPLE before performing a backup.  Guess back to the drawing board.

Thanks again though.  I will reward the points as soon as I get it backed up correctly.
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

  • 7
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now