• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 279
  • Last Modified:

how to copy a database

Hello experts,

I need to copy a complete database, including store procedures, tables and so on into another emty database.
I am new to this and I was wondering if you know any tutorial with pictures step by step using the wizard method.

I am using MSSQL 2008

Thank you
0
shpresa
Asked:
shpresa
  • 2
1 Solution
 
barletCommented:
You can do it with backup and restore...
Right click on your database and backup/restore

This is rhe easiest way...
0
 
IT-Monkey-DaveCommented:
I've done this several times using SQL Server's built-in backup and restore.  Works like a charm.
0
 
barletCommented:
Have a look at the following link
 http://www.codebarlet.com/2012/01/19/database-backup/
0
 
lcohanDatabase AnalystCommented:
Why not just use the SQL built in "Copy" feature from SSMS??
Just right click on a SQL 2008 SSMS then select "Copy Database.." from the drop down menu and follow the easy to use wizzard.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now