July 10, 2009 at 1:12 am
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!
July 10, 2009 at 1:40 am
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
October 20, 2009 at 5:37 pm
thanks!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply