SharePoint By Yagya Shree

Posts Tagged ‘backup

How to move content database from one SQL server to another SQL server and get the sharepoint site collection up & running

leave a comment »

1. Backup you content database from old SQL server. If you already have a backup no need to do this step.

2. Restore the database on the new SQL server and note down the name of the database

3. Go to your Central administration–application management–create and extend site, create a new web application and give the database name as “dummydatabase”. you can use any service account who is the farm administrator

4. Now go to Central Administration–application management–content databases, Here change it to the newly created web application

5. Here put the check mark in “Remove content database” and click “Ok”

6. Now open your command prompt and go to “C:\program files\common files\microsoft shared\web server extensions\12\bin”

7. Run the following command

stsadm.exe -o addcontentdb -url <new web application name> -databasename <new restored database name>



Written by Yagyashree

June 2, 2009 at 1:45 am

SharePoint Full Farm Backup Using Central Administration Page

leave a comment »

1. Symptom –

–>You are trying to perform SharePoint farm backup from central administration on to a remote location whose address is  \\backupservername\sharepointbackup but it is not making any progress or showing any status change on the page “Backup and restore status” page i.e. Backupstatus.aspx

–>It only shows the message “There are no current or recent backup or restore processes to show. If you recently started a backup or restore process, you may need to refresh this page after several minutes for it to appear.”

2. Cause –

–>SharePoint server did not had the proper permission on the server

3. Resolution –

–>You need to add the SharePoint server name i.e. “<Domain name>\sharepointservername$” to the UNC path location \\backupservername\sharepointbackup with “Full control” permission

4. Environment

SQL Server

SharePoint Server

Backup Server


All in same domain but three different machines

Written by Yagyashree

May 27, 2009 at 2:53 am

%d bloggers like this: