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:

- 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.
rsnellmanIT ManagerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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.
rsnellmanIT ManagerAuthor 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?

Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

rsnellmanIT ManagerAuthor 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.
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.
rsnellmanIT ManagerAuthor 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

"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.
rsnellmanIT ManagerAuthor 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:

Windows Authentication

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

System Databases

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

rsnellmanIT ManagerAuthor 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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.