.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

How to move database from one machine to another

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :Sql Server

Using VS2010 and SQLEXPRESS (2008 I presume), I started a project on one computer (in another city) and would like to continue on my laptop, but I have only the MDF file (e.g. c:\Program Files\etc\etc\DATA\foo.mdf)

I've tried a variety of approaches, but nothing works. Anybody know how to make this work?




View Complete Post

More Related Resource Links

Facing MSDTC related issues while archiving data from one database server machine to another databas

I have a question with respect to distributed transactions when carried out between two database server machines on the same network.   Consider there are two database server machines \SOURCE_DATABASE_SERVER\ and \DESTINATION_DATABASE_SERVER\. Now we have to archive the data from one database server to other database server.   Let us suppose the database server \SOURCE_DATABASE_SERVER\ is the live production database server and \DESTINATION_DATABASE_SERVER\ is Long term storage database server. Now data from \SOURCE_DATABASE_SERVER\ needs to be archived into the database server \DESTINATION_DATABASE_SERVER\.   So I have written a dynamic stored procedure which includes distributed transaction (begin Tran, commit Tran, rollback            Tran) coding in it.   Now initially when I executed the procedure, it gave some of the following errors   1) OLE DB provider "SQLNCLI" for linked server "\DESTINATION_DATABASE_SERVER\" returned message "The partner transaction manager has disabled its support for remote/network transactions.". Msg 7391, Level 16, State 2, Line 1 The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "\DESTINATION_DATABASE_SERVER\" was unable to begin a distributed transaction.    

Database Table: Move row to the top of the table???

I have a table in my aspnet database.  I added a bottom row "Not Selected", if the user doesn't select from a databound drop down list.  This row is at the bottom, because I just added it to the table data.  Is there any way to move this one row to the top of the table manually?  There is not "cut" and "paste" when I select the whole row.Any idea how to do this?  Thanks in advance. :)

Database backup on Sql Client Machine

Hi there, I am using SQL server 2008 and I need to take a back up of my database on the local client machine instead of the server. I understand that the back up wizard lists only the server machine's drives and directories. Is there any way to create the back up on my local client machine instead of server. Thanks & Regards, Hari.

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!

installing SSRS 2008 R2 on a separate machine than the SS 2008 R2 database



I set up SQL Server 2008 R2 along with SSRS on a Windows 2008 server--let's call it "SQLDB"--and all's working fine.  I'm able to upload reports that are pulling data from the SQLDB databases.  There is no problem.

However, the operations dept. now tells me that a server with SQL Server installed absolutely will not be made available to the users and so I will need a separate SSRS 2008 R2 server (named "SQLRS") that pulls data from SQLDB databases.  Basically, I need to stop using SSRS on SQLDB and start using SSRS on SQLRS.  Makes sense to me, although I've never done this.

I'm confused about what services and components of SQL Server 2008 R2 need to be installed on which server(s).  Could somebody please point me to a page that explains it thoroughly or, if it's fairly simple, explain it for me here? 

For instance, "SQLDB" has SSAS, SSIS, database engine, SQL Browser, Management Tools, and SQL Agent installed. 

On "SQLRS", I installed SSRS, database engine, SQL Agent, SQL Browser, Management Tools, and SQL Agent.  Was it necessary to install the database engine, considering the data to be pulled is on "SQLDB"?  I read that the Agent is only required for subscriptions, but what about SQL Browser?  Is it only required on s

Move WSS 3.0 to a virtual machine

We have WSS 3.0 running on a Windows 2003 R2 server, and the database is on another SQL server.  We will convert the 2003 server into a virtual machine, and also will move the database into the same VM as well.  What do I need to do the migrate the database?  And will I lose anything such as content and configuration?  Thank.  

Move Configuration Database to a different server



When installing Sharepoint, I accidentally selected to install it as a SQLEXPESS server located at ComputerName\Sharepoint and didn't notice. When my site hit the 4 gig limit, I moved the content database to another server quite easily.


Now I'm wondering if it is best practice to make sure that everything is on the same server. Poking around in Central Administration I notice quite a few references to the Sharepoint server, and then my Content Database which is off on it's own. Is there an easy way to migrate everything over to my new server (a cursory glance around google hasn't turned up anything yet) or should I leave it fragmented as it is?




Move the database files to different branches before replication?


Hi all,


I want to start a replication between 3 sites using Merge replication, 1<sup>st</sup> branch is the distributer and publisher and already has a database, the others are subscribers and they are new (No data yet). But the size of the database in the main branch is about 4 GB. So if I start the replication, 4 GB will be replicated which something I don’t want. Is there a way I can put the database in the other branches manually? So nothing will need to replicate at the first time. And then replication will take place.


Waiting your valuable reply,




rename SQL 7 database and move to SQL 2005

I need to move an SQL 7 database to an SQL 2005 server that already has a database with the same name. The SQL 7 database needs to have a new name and not affect in any way the one that's already on the 2005.  How can I do this? Do I need to rename the 7 database before I back it up, and if so, how do I do this so everything (log files, etc) reflect the new name so nothing crushes anything on the 2005?

Sharepoint 2010 database on different machine



i have to ask a question that is it possible that Sharepoint 2010 Server could be installed on a machine which has no SQL server installed previously and sharepoint 2010 configuration Database could reside elsewhere (on a different machine) ?


SharePont 2003 - Move content database


I have been unable to use Backup Restore because the topology was unsupported.

I have successfully moved the config database.

Now I have backed up and restored the SQL database for the content db and am having trouble finding out how to attach the content database back in to sharepoint.

I normally use SP2007 but am having trouble locating the attach content db stsadm command.  It may even be possible through Central Admin.

Anyone know how this is done?

How to create SQL Database Backup on a remote machine through Backup Class provided by C#?


I need to take SQL database backup on a remote machine through C#. I am using Backup Class provided by Microsoft.SqlServer.Management.Smo namespace.

When I call SqlBackup function of Backup Class I get the following error:

Cannot open backup device '\\WKS-123\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\CalDBServer.bak'. Operating system error 53(The network path was not found.).
BACKUP DATABASE is terminating abnormally.

I have already shared folder \\WKS-123\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\ with "Full Control" permissions.

Please let me know if anybody has any idea regarding the error.






I am a bignner in DATABASE TECHNOLOGY,I have a Remote server for my web site on which I have database and I want to change my Database Server and I want to move My all the Database from one  remote Serever to another remote server..Please help me as soon as possible ..

Cannot connect to the configuration database - after IIS reset or machine reboot


After an IIS reset or rebooting the machine.  If I then open up a sharepoint website the message is Cannot connect to the configuration database. as detailed below


Server Error in '/' Application.

Cannot connect to the configuration database.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: Microsoft.SharePoint.WebPartPages.WebPartPageUserException: Cannot connect to the configuration database.

Source Error:

Moving All Sharepoint Database to different machine



I am having Sharepoint 2010 Enterprise RTM Trial (Single Server Installation) on Windows Server 2008 SP2 and Databases are managed by SQL Server 2008 (not r2).

I want to move backend Databases to another machine for better performance. I have read the following article:


I need to know is there any alternate that can migrate all databases with ease ?

can I take backup of all databases, then restore them on another server and make connection to Sharepoint ? (if yes, please provide necessary details)


Move SharePoint Foundation 2010 database from SQL 2008 R2 Express to SQL 2008 R2 Standard.


Currently, our Sharepoint Foundation 2010 's is installed in same server with SQL 2008 R2 express hosting the databases. We would like to move all the Sharepoint Foundation 2010 database to a new SQL 2008 R2 Standard Server. Can it be done?

In this technet document, http://technet.microsoft.com/en-us/library/cc512725.aspx, it stated "The new database server must be running the same version of Windows Server and Microsoft SQL Server as the existing database server." Does it mean that I cannot move the database to  SQL 2008 R2 Standard Server?

Unable to connect to SQL Server 2008 R2 Database without being admin of the machine


I am receiving the following error when I try to connect to my new SQL Server 2008 R2 machine:


Msg 18452, Level 14, State 1, Server <server name>, Line 1 Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.

I'm running the following command to test the connection:

sqlcmd -S<Server Name> -E -Q"Select @@servername"

On the server I'm getting the following from the SQL Server logs


03/31/2011 20:31:58,Logon,Unknown,Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. [CLIENT:]

03/31/2011 20:31:58,Logon,Unknown,Error: 18452<c/> Severity: 14<c/> State: 1.

03/31/2011 20:31:58,Logon,Unknown,SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT:]

03/31/2011 20:31:58,Logon,Unknown,Error: 17806<c/> Severity: 20<c/> State: 2.

What is odd is if I put the domain user in as Admin of the machine then it connects just fine.  I have tried just about everything I can find and I just cannot get it to work. Anyone have any clues???


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