copy error

Can someone point me in the right direction to figure out
what's wrong here?
I'm trying to copy a very simple DB between two servers
using the SQL 2000 Enterprise Manager DB Copy Wizard. All
steps looks good up to detaching the source DB, but then
the actual copy of the share database mdf file to the
destination server fails. The Error Code in the Task
Detail box is 'failed'. The Error Code in the Step Detail
box is '-2147467259'.
The Package Log Error Description is:
Step Error Source: Microsoft Data Transformation Services
(DTS) Package
Step Error Description:Unspecified error
Step Error code: 80004005
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:1100The reason and solution to your exact error/problem are given at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;274463&Product=sql2k
"Tech - SBT" <bglynn@.sbtontheweb.com> wrote in message
news:1MCjb.147527$Of2.4215035@.twister.tampabay.rr.com...
> Can someone point me in the right direction to figure out
> what's wrong here?
> I'm trying to copy a very simple DB between two servers
> using the SQL 2000 Enterprise Manager DB Copy Wizard. All
> steps looks good up to detaching the source DB, but then
> the actual copy of the share database mdf file to the
> destination server fails. The Error Code in the Task
> Detail box is 'failed'. The Error Code in the Step Detail
> box is '-2147467259'.
> The Package Log Error Description is:
> Step Error Source: Microsoft Data Transformation Services
> (DTS) Package
> Step Error Description:Unspecified error
> Step Error code: 80004005
> Step Error Help File:sqldts80.hlp
> Step Error Help Context ID:1100
>|||I read that and don't see the exact problem. MORE INFO does not give me any
details nor an exact error.
"I_AM_DON_AND_YOU?" <user@.domain.com> wrote in message
news:%23eK7ukClDHA.2060@.tk2msftngp13.phx.gbl...
> The reason and solution to your exact error/problem are given at:
>
http://support.microsoft.com/default.aspx?scid=kb;en-us;274463&Product=sql2k
>
> "Tech - SBT" <bglynn@.sbtontheweb.com> wrote in message
> news:1MCjb.147527$Of2.4215035@.twister.tampabay.rr.com...
> > Can someone point me in the right direction to figure out
> > what's wrong here?
> >
> > I'm trying to copy a very simple DB between two servers
> > using the SQL 2000 Enterprise Manager DB Copy Wizard. All
> > steps looks good up to detaching the source DB, but then
> > the actual copy of the share database mdf file to the
> > destination server fails. The Error Code in the Task
> > Detail box is 'failed'. The Error Code in the Step Detail
> > box is '-2147467259'.
> >
> > The Package Log Error Description is:
> >
> > Step Error Source: Microsoft Data Transformation Services
> > (DTS) Package
> > Step Error Description:Unspecified error
> >
> > Step Error code: 80004005
> > Step Error Help File:sqldts80.hlp
> > Step Error Help Context ID:1100
> >
> >
>
>

Copy Database?

I am developing a database at the moment and have reached a point where I
would like to copy the database to another database.
ie. I'm working on database test1 and want to create a database test2 which
is a copy of test1.
Can't work out a simple way to do this although I'm sure I've done it before
(too many late nights, brain is obviously truncating things). Copy wizard
tells me I can't copy to the same server, presumeably because there is no
option to rename the copy.
Can anybody shed some light on this please (no laughing at the simple
question).
thanks
GavGav
BACKUP DATABASE... and then RESTORE with a new name. Please take a look at
BOL for more details
"Gav" <gav@.nospam.com> wrote in message
news:%23jnrIG67HHA.3716@.TK2MSFTNGP03.phx.gbl...
>I am developing a database at the moment and have reached a point where I
>would like to copy the database to another database.
> ie. I'm working on database test1 and want to create a database test2
> which is a copy of test1.
> Can't work out a simple way to do this although I'm sure I've done it
> before (too many late nights, brain is obviously truncating things). Copy
> wizard tells me I can't copy to the same server, presumeably because there
> is no option to rename the copy.
> Can anybody shed some light on this please (no laughing at the simple
> question).
> thanks
> Gav
>|||"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uO1i%23I67HHA.4736@.TK2MSFTNGP06.phx.gbl...
> Gav
> BACKUP DATABASE... and then RESTORE with a new name. Please take a look
> at BOL for more details
Ha Ha. Cheers for that <feeling silly> :o)
>
> "Gav" <gav@.nospam.com> wrote in message
> news:%23jnrIG67HHA.3716@.TK2MSFTNGP03.phx.gbl...
>>I am developing a database at the moment and have reached a point where I
>>would like to copy the database to another database.
>> ie. I'm working on database test1 and want to create a database test2
>> which is a copy of test1.
>> Can't work out a simple way to do this although I'm sure I've done it
>> before (too many late nights, brain is obviously truncating things). Copy
>> wizard tells me I can't copy to the same server, presumeably because
>> there is no option to rename the copy.
>> Can anybody shed some light on this please (no laughing at the simple
>> question).
>> thanks
>> Gav
>|||You also perform the following alternative methods:
- Take your database offline and copy the mdf and ldf files and rename them.
And then Attach them.
- Detach your database and copy the mdf and ldf files and rename them. And
then Attach all of them.
- Copy your database with Copy Database Wizard. Go to your database right
click on it Tasks\Copy Database
But the easiest one is back and restore anyway :)
--
Ekrem Önsoy
"Gav" <gav@.nospam.com> wrote in message
news:uKhrsP67HHA.5796@.TK2MSFTNGP05.phx.gbl...
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:uO1i%23I67HHA.4736@.TK2MSFTNGP06.phx.gbl...
>> Gav
>> BACKUP DATABASE... and then RESTORE with a new name. Please take a look
>> at BOL for more details
> Ha Ha. Cheers for that <feeling silly> :o)
>>
>> "Gav" <gav@.nospam.com> wrote in message
>> news:%23jnrIG67HHA.3716@.TK2MSFTNGP03.phx.gbl...
>>I am developing a database at the moment and have reached a point where I
>>would like to copy the database to another database.
>> ie. I'm working on database test1 and want to create a database test2
>> which is a copy of test1.
>> Can't work out a simple way to do this although I'm sure I've done it
>> before (too many late nights, brain is obviously truncating things).
>> Copy wizard tells me I can't copy to the same server, presumeably
>> because there is no option to rename the copy.
>> Can anybody shed some light on this please (no laughing at the simple
>> question).
>> thanks
>> Gav
>>
>