Go 4 Sharepoint

Search:

Welcome: Guest!

Sharepoint Forum

Home » Forum » Sharepoint

Ask a question

RSS Feeds

Backup/Restore WSS Databases from Production to Test Using SQL Server

Asked By: Devika Goud Date: Aug 15, 2006 Category: Sharepoint Views: 591

I need a test copy of my WSS website content on a development server. I
tried the procedures outlined in the Microsoft article "Backing Up and
Restoring Databases by Using the SQL Server 2000 Tools", but the result
was that my new development WSS virtual server is pointing to the
Production content database on the original server. Has anybody
successfully replicated a content database onto a different server by
just the SQL Server backup/restore? The end result I need is to have a
development server with a copy of my production content that I could
refresh at any time for testing purposes.

Tagged:backuprestore wss databases from production to test using sql server

6 Answers Found

Answer #1 Answered By: Christop Mcfadden Answered On: Aug 15, 2006

i have successfully done this with smigrate. using the SQL utility is not the
way to go.

Answer #2 Answered By: Victoria Bell Answered On: Aug 15, 2006

Is it possible to write a script using smigrate that will
automatically duplicate the sharepoint portal onto another machine
nightly?

We want to have a mirror of our portal that is off by one day. We
are already doing that with the embedded sites.

Answer #3 Answered By: Cassidy Sharpe Answered On: Aug 15, 2006

Its entirely possible. Script a backup to a directory, script a restore to a site.. Seems pretty easy. It will need to be 2 scripts because you cant smigrate across wss “instances”.

Answer #4 Answered By: Linda Mason Answered On: Aug 15, 2006

It is possible, but depending on how many top level sites this could become overly complex and time consuming. How do you plan on moving the files to the other server? Do you want to retain user permissions?

Answer #5 Answered By: Hans Weiss Answered On: Aug 15, 2006

You will not be able to use smigrate for the portal (SPS) - it only works for WSS sites.

Answer #6 Answered By: Alison West Answered On: Aug 15, 2006

My mistake, stsadm is the utility. Bob Fox has a good write up on the basics of backups. http://bobfox.net/spnj/docs.aspx

Didn't find what you were looking for? Find more on Backup/Restore WSS Databases from Production to Test Using SQL Server Or get search suggestion and latest updates.