Solved

Copy a SQL Server 2008 database to another machine

Posted on 2013-06-14
6
516 Views
Last Modified: 2013-06-15
I backed up my database named StockProSQL to a thumb drive.
The backup in named StockProSQL.bak

SQL Server 2008 is installed on the destination machine

How do I copy it to my destination machine?

Thanks
0
Comment
Question by:Dovberman
6 Comments
 
LVL 22

Accepted Solution

by:
Haresh Nikumbh earned 150 total points
ID: 39247194
Please refer step by step guide for restoring SQL database on another machine

http://www.techrepublic.com/blog/window-on-windows/how-do-i-restore-a-sql-server-database-to-a-new-server/454
0
 
LVL 22

Assisted Solution

by:Haresh Nikumbh
Haresh Nikumbh earned 150 total points
ID: 39247198
you can also refer video for backups and restore

http://www.youtube.com/watch?v=9U7QxPsA0tw
0
 
LVL 2

Assisted Solution

by:vivekkumarSharma
vivekkumarSharma earned 75 total points
ID: 39247212
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 11

Assisted Solution

by:SThaya
SThaya earned 75 total points
ID: 39247239
0
 

Author Comment

by:Dovberman
ID: 39247917
Perhaps I do not have a good backup. The restore to a new database worked.

However I have an empty new database.
0
 

Author Closing Comment

by:Dovberman
ID: 39249700
Thank you
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question