Solved

Copy a SQL Server 2008 database to another machine

Posted on 2013-06-14
6
513 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
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

932 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now