Copy database using SQL 2005

• cute_lhen05

  SSC Eights!

  Points: 989

  More actions

  July 10, 2009 at 1:12 am

  #208108

  Good day,

  I am having a hard time copying the database using sql 2005; I already logged in as db owner; i am getting error code 1073548784. i used the 2nd option:use the sql Management object method;

  thanks!

• Johan Bijnens

  SSC Guru

  Points: 135361

  More actions

  July 10, 2009 at 1:40 am

  #1022872

  What extra info is given with your error number ?

  I suggest to use the "regular" restore scenario.

  Create a backup of the original db using

  backup database xyz to disk=c:\temp\mybackup.bak' with copy_only

  Then copy mybackup.bak to your sqlexpress backup folder.

  Connect to your sqlexpress and perform the restore.

  (using SSMSE(gui) or writing your ownd restore database xyz from disk=...

  Keep in mind SQLExpress has limitations in db-size ! (4Gb max)

  Johan
  
  Learn to play, play to learn !

  Dont drive faster than your guardian angel can fly ...
  but keeping both feet on the ground wont get you anywhere :w00t:

  - How to post Performance Problems
  - How to post data/code to get the best help[/url]

  - How to prevent a sore throat after hours of presenting ppt

  press F1 for solution, press shift+F1 for urgent solution 😀

  Need a bit of Powershell? How about this

  Who am I ? Sometimes this is me but most of the time this is me

• cute_lhen05

  SSC Eights!

  Points: 989

  More actions

  October 20, 2009 at 5:37 pm

  #1068608

  thanks!