locked
backup and restore RRS feed

  • Question

  • we copy a db files from server 1 and plan to restore it at another sharepoint server, server 2.  The question is in the second server, the c drive doesn't have enough space to perform a restore. The question is if we move the db files from server 2 to the d: drive in server 2 then perform the restore, does it work or the restore must be done in c: drive on the server 2? 

    thank you.

    • Moved by Mike Walsh FIN Wednesday, September 7, 2011 4:51 AM admin q (From:SharePoint - General Question and Answers and Discussion (pre-SharePoint 2010))
    Tuesday, September 6, 2011 5:25 PM

Answers

All replies

  • Hi,

    what do you mean by db file? have you taken back up of your SharePoint site's SQL Server content database directly? or you have taken backup using stsadm command?

    but anyways, I think there wont be any problem even If you place those back up file on C:\ or D:\ of your second server.

    also take a look at URL http://metahat.blogspot.com/2008/11/backup-restoring-sharepoint-2007-site.html

    http://sharepointdogs.wordpress.com/2008/07/30/content-migration-or-backuprestore-in-moss-2007

    hope this helps you


    Bhushan | http://www.passionatetechie.blogspot.com | http://twitter.com/BhushanGawale
    • Edited by Bhushan Gawale Tuesday, September 6, 2011 5:59 PM added links
    • Marked as answer by Pengyu Zhao Tuesday, September 13, 2011 9:04 AM
    Tuesday, September 6, 2011 5:55 PM
  • The Way of restoring the site using db file is.....

    First restore your db into sql server. then start the below process

    1) first you need to create the web application(use top level site collection would be the blank site).

    2) then go to central admin remove your data your database from your web application.

    3) add your db to the same place where you have removed you db.

    4) go to stsadm command and use below syntax for attach your db to created web application.

    Syntax

    stsadm.exe -o addcontentdb

    -url <URL name>

    -[-assignnewdatabaseid]

    -[-clearchangelog]

    -databasename <database name>

    [-databaseserver <database server name>]

    [-databaseuser <database username>]

    [-databasepassword <database password>]

    [-sitewarning <site warning count>]

    [-sitemax <site max count>]

    example:

    stsadm -o addcontentdb -url <var>http://URLofWindowsSharePointServicesSite</var> -databasename databasename -databaseserver <var>DatabaseServer</var>

     

    Hope this will help you

    Wednesday, September 7, 2011 2:46 AM