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.

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

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