Solved

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

Posted on 2012-03-13
11
641 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
 

Author Comment

by:rsnellman
Comment Utility
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
Comment Utility
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
Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

 

Author Comment

by:rsnellman
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
Just wss content.
0
 

Author Comment

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

Thanks.
0
 

Author Comment

by:rsnellman
Comment Utility
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

In this article I will describe the Backup & Restore 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.
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.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

762 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now