.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Restoring content database to another server

Posted By:      Posted Date: October 11, 2010    Points: 0   Category :SharePoint
I am using sharepoint server 2007,I took a backup of content database and want to restore it to the content databse to another server,without creating a new web application,how can i do this

View Complete Post

More Related Resource Links

after restoring content database getting error (HTTP/1.1 200 OK Server: Microsoft-IIS/7.5 Date: Tue,

Hi All, Problem i have taken backup of Old site content database procedure see below 1) first i changed the database to read only mode (Opened SQL Server2005-->selected DB--> properties--> Option-->Database Read-Only=True) 2) taken backup of database from the task--Backup(new.bak) 3) Copied the taken backup to new server and restored (Opened SQL Server2005 --> Right Click on Database Folder--> Restore Dataase) In To database: ihave given DB name From Device: i have selected database from the location where i have saved. click ok.  It has restored successfully 4) I have created a new webapplication and removed its content database from central admin. 5) with the help of stsadm command i restored the above db to this webapplication. then iam getting below error: HTTP/1.1 404 Connection: close Date: Tue, 14 Sep 2010 06:20:08 GMT Server: Microsoft-IIS/6.0 X-Powered-By: ASP.NET MicrosoftSharePointTeamServices: i have refered the below url for restoring http://metahat.blogspot.com/2008/11/backup-restoring-sharepoint-2007-site.html Please help. Thanks in advance.

Restoring a content database from another server/AD does not synch user profile information for new


In my SharePoint 2010 beta environment, I have user profiles synching with Active Directory.  I just restored a content database from a separate environment/domain and logged in with my current account.  When I try to create an alert on a library/item, I get the error:

“You do not have an e-mail address.  Alert has been created successfully but you will not receive notifications until valid e-mail or mobile address has been provided in your profile.”

I went to My Profile and found that the My Profile had the right e-mail address (I guess because this is on my My Site Host).

But when I went to My Settings, it did not have any e-mail address for me (I guess this is because it is at the WSS content database level and the e-mail address hasn’t yet synched from the user profile database).

Does anyone the timer job that synchs the user profile with the My Settings for a site collection in a content database?

Issue is posted to my blog with screenshots here:



How to get access to content database after server hardware failure


Sharepoint server 2007 and remote sql 2000 SP4 database, after ShraPoint server crash only content databases are available and intact. Trying to restore from backup fail, stsadm -o restore says that not valid backup is available on path. How to get access to available content database using a new installation with same server name, ip address and partitions configuration. How to recover site with content databases information.

Regards, thanks for help.

Victor Naranjo MCSE + Security MCSA + Security MCSE + Messaging MCSA + Messaging ITIL Certified Comptia Security+

Failure in restoring an database from tape - SQL Server 2005

Hello everyone, we are trying to restore one of our datebase from tape using the T-Sql commands. Using the GUI results in an timeout. The command we are using to start the restore is: RESTORE DATABASE RECOV FROM Tape = '\\.\tape0' WITH  FILE=2, RECOVERY, NOUNLOAD, STATS=5, MOVE 'xxx_OPL_xxxx_ZEELAND' TO 'K:\RECOVER\data\RECOV.mdf', MOVE 'xxx_OPL_xxxx_ZEELAND' TO 'K:\RECOVER\log\RECOV_log.ldf', REPLACE the restore proces start without any problem, only ending with this: Processed 2598808 pages for database 'xxx_OPL_xxxx_ZEELAND', file 'xxxx_PROD_Data' on file 2. Processed 3 pages for database 'xxxx_OPL_xxxx_ZEELAND', file 'xxxx_PROD_Log' on file 2. Msg 3229, Level 16, State 2, Line 1 Request for device '\\.\tape1' timed out. Msg 3213, Level 16, State 1, Line 1 Unable to unload one or more tapes. See the error log for details. Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally. In the eventlog, the following is recorded: BackupTapeFile::UnloadTape: PrepareTape(UNLOCK) failure on backup device '\\.\tape0'. Operating system error 21(The device is not ready.). For as far we can judge, the tapedrive is functioning without problems. Using the same tape in an other tapedrive on an different server results in the same error. Hardware used: HP Proliant Server (DL580) with additional SCSI interface card HP StorageWorks LTO 4 tapedriv

Restoring a database on server X but while in a database on server Y

I am trying to execute the following but it always fails. I am on server 'X'. I back up a database on server X, then restore a database on server Y using the newly created backup. The database DB1 exists on both servers of X and Y.How can I execute the intended SQL statements below without errors? I am executing these statements from server X.BACKUP DATABASE [X].[DB1] TO  DISK = N'F:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\DB1.bak' WITH NOFORMAT, INIT,  NAME = N'BFI_SCPJD-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10GORESTORE DATABASE [Y].[DB1] FROM  DISK = N'F:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\DB1.bak' WITH  FILE = 1,  NOUNLOAD,  REPLACE,  STATS = 10GO

Restoring Database taking long time in SQL Server 2008 R2 -- some how urgent


Hi all

I have Database size 12GB in SQL Server 2005 and It is backed up.

Now I tring to restore Database in SQL Server 2008 R2(wizard)....it is not at complted after 2hours...still running.


any idea..or help appreciated..



Move Single MOSS Content Database to Different SQL Server

We want to mmove the single database of MOSS on Network Test and Development to the Production SQL Server. But MOSS aplication server remains same!

So in this condition it points out for the two database servers at the same time.

Is it possible? Or I need to migrate the all concern databases to the another SQL Server?

Pls HelP!

Restoring a Content Database to an earlier MSSQL backup?

We'd like to roll back a content database to an earlier point in time. Is this doable by just shutting down the frontend, and then restoring the MSSQL WSS_Content database, or are there some quirks that we need to take into account?

Unable to connect to the SQL content database from sharepoint web front server.



SharePoint farm is as below. 1 SQL, 1 WFE, 1 Application server. SQL 2005 and SharePoint 2007 with SP1.

SharePoint portal is working fine from 1 year, suddenly from today morning in the WFE eventvwr we are getting 27745, 3355 and 5586 event id errors. Site also giving error saying "unable to connect the content database". This is repeating for 10 to 15 min.

when ever these errors occur in eventvwr sharepoint will not work.

Please suggest on this issue.

waiting for MS replies..






Restoring sql server database with stored procedures



I have a database that needs restoring to get a website up and running.  I am not a ASP developer (am PHP) and therefore have never used SQL Server before.

I have just tried to import one of the tables from a .txt file using SQL Server Management Studio 8 and instead of the column names being inputed, it just has "column 0", "column 1" etc.  I have noticed that I have a folder full of stored procedures, am I supposed to import these first?  Im not 100% what these stored procedures are for or the best way for me to import all this data successfully as I have so many files it will take forever to import one by one.  I dont mind doing it one by one if I have to but just want to ensure I do it all correctly first time!

Many thanks

Restoring a SQL Server database through code


Hi all,

I'm trying to restore a sql server 2k8 database from a .bak file.  I've tried using two methods and both are unsuccessful.  I've tried using the SMO classes and the error that I get is simply "restore failed for <serverName>".  I also tried to simply run a query with the proper syntax for restoring a database.  This runs but I get an error message that says the timeout expired.  I tried extending the timeout through the connection string to 20 mins but it still fails within a minute.

This is my code:

SMO Method:

    private static void restore(string dbName, string fPath, string dataFilePath, string logFilePath)
            Restore sqlRestore = new Restore();

            BackupDeviceItem deviceItem = new BackupDeviceItem(fPath, DeviceType.File);
            sqlRestore.Database = dbName;

            SqlConnection sqlCon = new SqlConnection("Data Source=ServerName;initial catalog=master;Integrated Security=True;");
            ServerConnection connection = new ServerConnection(sqlCon);
            Server sqlServer = new Server(connection);

            sqlRestore.Action = RestoreActionType.Database;
            string dataFileLocation = dataFilePath + dbName + ".mdf";

Error when restoring database to different server from .dat and .ldf


We are using SQL Server 2005. I was given a client's .dat and .ldf files and asked to restore it on our server. I ran the following sql statement:

DISK = 'C:\LytecData\MSSQL$LYTEC_SQL\MSSQL\Backup\3rdPartyDBs\Womens\WGAP.dat'

This statement gave me the following error:
Msg 3241, Level 16, State 0, Line 1
The media family on device 'C:\LytecData\MSSQL$LYTEC_SQL\MSSQL\Backup\3rdPartyDBs\Womens\WGAP.dat' is incorrectly formed. SQL Server cannot process this media family.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

I used this statement to restore bak files for clients, but I seem to be having trouble restoring from the .dat file. I would appreciate any help that you could provide.


Restoring a SQL Server 2000 database having only the .mdf file


Hi all,

SQL Server 2000, I need to restore a database, I've only the .mdf file, note that the database was not gracefully detached, so the sp_attach_single_file_db fails. Is there any other way?

MS SQL Server: Disconnect Users From Database - Kill User Session

If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.

Publishing SQL Server Database using Publishing Wizard : Tips & Tricks

We can use SQL Server Publishing Wizard to deploy our local Database to remote hosting server/production server.This feature is available in SQL Server 2008/VWD 2008.

Below is the complete step by step guide of this process.

Connestion string create any database server

This links important to how to create connection string to any data base sever.

SQL Server Database Transaction

A transaction is a group of SQL commands executed together as a single component of work to be accomplished. If all of these commands succeed, then a transaction is committed - the changes to the data are made final. If any of the commands within a transaction fail, then the entire transaction is cancelled, or in SQL Server terms, the transaction will be rolled back.

Transactions are one of the things that keep your data safe, but they're not necessarily easy to understand. Here's some help:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend