Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

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

  Asked By: Devika    Date: Aug 15    Category: Sharepoint    Views: 5449

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.



6 Answers Found

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

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

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

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

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

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

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

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