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

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>

Refer:
—–
http://technet.microsoft.com/en-us/library/cc263422.aspx

SharePoint Full Farm Backup Using Central Administration Page

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