Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 275
  • 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

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

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