Solved

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

Posted on 2012-03-13
11
676 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

830 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