Solved

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

Posted on 2012-03-13
11
666 Views
Last Modified: 2012-03-16
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
Comment
Question by:rsnellman
  • 7
  • 4
11 Comments
 
LVL 38

Accepted Solution

by:
Justin Smith earned 500 total points
ID: 37715557
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
 
LVL 38

Assisted Solution

by:Justin Smith
Justin Smith earned 500 total points
ID: 37715565
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
 

Author Comment

by:rsnellman
ID: 37716099
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
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 

Author Comment

by:rsnellman
ID: 37716105
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
 
LVL 38

Assisted Solution

by:Justin Smith
Justin Smith earned 500 total points
ID: 37716145
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
 

Author Comment

by:rsnellman
ID: 37716689
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
 

Author Comment

by:rsnellman
ID: 37716725
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
 

Author Comment

by:rsnellman
ID: 37716736
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
 
LVL 38

Assisted Solution

by:Justin Smith
Justin Smith earned 500 total points
ID: 37716775
Just wss content.
0
 

Author Comment

by:rsnellman
ID: 37717180
OK.  Have it backed up and have copied it over to the test server (SharePoint Foundation 2010).

Thanks.
0
 

Author Comment

by:rsnellman
ID: 37717255
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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question