Solved

sharepoint 3.0 Exporting/backing sharepoint database

Posted on 2011-03-08
6
260 Views
Last Modified: 2012-05-11
I have a SERVER1 running WSS 3.0 and SERVER2 running WSS 3.0. I want to create a top level site on SERVER2 and import the content database from SERVER1. However, I dont know how to backup the content database without backing up the config database, because I wont need it. I just need the content DB. How would I do this. Thanks.
0
Comment
Question by:fstinc
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 3

Accepted Solution

by:
CarlsbergFTW earned 500 total points
ID: 35074240
you can do that in several ways, but you could try to back-up only the needed or specified tables separately then run the query on your new server assuming you're using linux + mysql the command you need to do (on the operatins system) is:

mysqldump -u[username] -p[password] --skip-opt --quick [dbname] [tablename1] | gzip -v -9 > /output/directory/[tablename1].sql.gz 

Open in new window

it will also archive your dump into a .gz format
0
 

Author Comment

by:fstinc
ID: 35074253
I would actually be backing up a SQL Server 2005 content database and restoring it on a SQL Server 2000.
0
 

Author Comment

by:fstinc
ID: 35074318
Nevermind. Netstat showed it was getting the database from a different server, thats where my confusion was at. Thanks
0
Backup Solution for AWS

Read about how CloudBerry Backup fully integrates your backups with Amazon S3 and Amazon Glacier to provide military-grade encryption and dramatically cut storage costs on any platform.

 
LVL 3

Expert Comment

by:CarlsbergFTW
ID: 35074319
There isn't a straightforward or simple way to do this but there are tools that can assist you with your back-up requirements

Try using this tool:
http://www.shabdar.org/downloads/Setup.zip

more information here:
http://www.shabdar.org/sql-server-backup-utility.html
0
 

Author Closing Comment

by:fstinc
ID: 35074325
Headed me in the right direction.
0
 
LVL 3

Expert Comment

by:CarlsbergFTW
ID: 35074348
Glad you got things right after all.

Have a nice day.
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

730 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