Kungen wrote:
> Hi!
>
> This question is a bit embarrasing since it's so basic.
>
> Copying a database in SQLserver2005 is done in tasks/copy. Now I'm
> using the Express Edition and there is no "Copy" function under
> "Tasks", so I did a copy of the DB right in the folder where it's
> physically located and tried to get the copy in by attaching it.
> Doesn't seem to be the right method, though. It tries to attach it to
> the DB that it is a copy of, so I guess I misunderstood the meaning of
> "attach".
>
> I just want to make a copy of a DB and I don't want the copy to have
> any connection to the DB it is a copy of.
>
> What do I do?
>

Kungen wrote:
> Thanks (again!) Tracy!
>
> I've found this in the help section, which I executed (my names):
>
> BACKUP DATABASE mydatabase
> TO mydatabaseBU ;
>
> RESTORE FILELISTONLY
> FROM mydatabaseBU ;
>
> RESTORE DATABASE mydatabaseCOPY
> FROM mydatabaseBU
> WITH MOVE 'mydatabase_Data' TO 'C:\MySQLServer\mydatabaseCOPY.mdf',
> MOVE 'mydatabase_Log' TO 'C:\MySQLServer\mydatabaseCOPY.ldf';
> GO
>
> I get this error message in return (translated from Swedish):
>
> Msg 3206, Level 16, State 1, Line 1
> There is no post in sysdevices for the backup unit 'mydatabaseBU'.
> Update sysdevices and execute the statement again.
> Msg 3013, Level 16, State 1, Line 1
> BACKUP DATABASE interrupted.
>
> Msg 3206, Level 16, State 1, Line 4
> There is no post in sysdevices for the backup unit 'mydatabaseBU'.
> Update sysdevices and execute the statement again.
> Msg 3013, Level 16, State 1, Line 4
> BACKUP DATABASE interrupted.
>
> Msg 3206, Level 16, State 1, Line 7
> There is no post in sysdevices for the backup unit 'mydatabaseBU'.
> Update sysdevices and execute the statement again.
> Msg 3013, Level 16, State 1, Line 7
> BACKUP DATABASE interrupted.
>
> I don't know what this means and searching the help section for
> "sysdevices" didn't return anything helpful.
>
> Sorry, but I'm stuck again.
>
> Thanks for your time.
>
> Kungen
>

Kungen wrote:
> Hi!
>
> Big thank you's for your patience.
>
> Yes I better bypass it because I don't know what it is...
>
> The problem is, as I wrote above, that when I use the script you
> supplied (thanks):
>
> RESTORE DATABASE mydatabaseCOPY
> FROM DISK = 'C:\mydb.bak'
> WITH MOVE 'mydatabase_Data' TO
> 'C:\MySQLServer\mydatabaseCOPY.mdf',
> MOVE 'mydatabase_Log' TO 'C:\MySQLServer\mydatabaseCOPY.ldf',
> REPLACE
>
> I get another error message that I don't understand either:
>
> Msg 3234, Level 16, State 2, Line 4
> The logical file mydatabase_Data is not a part of the database
> mydatabaseCOPY. Use RESTORE FILELISTONLY to retrieve a list of the
>
> names for the logical files.
> Msg 3013, Level 16, State 1, Line 4
> RESTORE DATABASE interrupted.
>
> What does it mean and what should I do?
> (Or, if your growing bored with my ignorance, could you please nod in a
> direction where I can find further guidance?)
>
> A very thankful
> Kungen
>