restore slq database to another server

I want to restore sql 2000 database to another server
I have already backup it up on server-a(the ortginal sql server)use sql
backup tool. I assume that the next steps is copy this file from server-a to
server-b(the new server) stop sql services on server-b and start restore
using the sql tool. Is this correct? or are they other steps I need to take?
Thankshttp://support.microsoft.com/defaul...b;en-us;Q314546
Jacco Schalkwijk
SQL Server MVP
"frank" <frank@.discussions.microsoft.com> wrote in message
news:0F31A8AC-2918-44D6-B1DF-1AAE9871181A@.microsoft.com...
>I want to restore sql 2000 database to another server
> I have already backup it up on server-a(the ortginal sql server)use sql
> backup tool. I assume that the next steps is copy this file from server-a
> to
> server-b(the new server) stop sql services on server-b and start restore
> using the sql tool. Is this correct? or are they other steps I need to
> take?
>
> Thanks
>|||You don't need to stop the SQL Server service.
Copy the file from server-a to server-b
Restore using either the Enterprise Manager or via Query Analyzer (my
preference)
You will also need to clean up your user and role information in the
restored db.
"frank" <frank@.discussions.microsoft.com> wrote in message
news:0F31A8AC-2918-44D6-B1DF-1AAE9871181A@.microsoft.com...
> I want to restore sql 2000 database to another server
> I have already backup it up on server-a(the ortginal sql server)use sql
> backup tool. I assume that the next steps is copy this file from server-a
to
> server-b(the new server) stop sql services on server-b and start restore
> using the sql tool. Is this correct? or are they other steps I need to
take?
>
> Thanks
>|||I do not want to move the database I just want to restore to another server
if possible with never sql down.
"Jacco Schalkwijk" wrote:

> http://support.microsoft.com/defaul...b;en-us;Q314546
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "frank" <frank@.discussions.microsoft.com> wrote in message
> news:0F31A8AC-2918-44D6-B1DF-1AAE9871181A@.microsoft.com...
>
>|||How did you backup the database? If you used SQL's BACKUP command or used
Enterprise Manager then the service on the target server has to be running
in order to restore it. If you are replacing an existing DB of the same name
then you need to use the REPLACE option on the RESTORE command (be very sure
you want to do this!).
If you backed-up the database file itself rather than use SQL's native
backup then just restore the file(s) to the target server and use
sp_attach_db to attach them. Again, no need to shut down the service.
David Portas
SQL Server MVP
--|||Just make backup of your database and follow the steps outlined in that
article. It doesn't mean you have to delete the database from the original
server after you have made a backup of it. That article just covers
everything you need to think of when either moving or copying databases
between servers.
Jacco Schalkwijk
SQL Server MVP
"frank" <frank@.discussions.microsoft.com> wrote in message
news:9F594C56-821F-4160-8689-6606A37E9F6B@.microsoft.com...[vbcol=seagreen]
>I do not want to move the database I just want to restore to another server
> if possible with never sql down.
>
> "Jacco Schalkwijk" wrote:
>sql

restore slq database to another server

I want to restore sql 2000 database to another server
I have already backup it up on server-a(the ortginal sql server)use sql
backup tool. I assume that the next steps is copy this file from server-a to
server-b(the new server) stop sql services on server-b and start restore
using the sql tool. Is this correct? or are they other steps I need to take?
Thanks
http://support.microsoft.com/default...;en-us;Q314546
Jacco Schalkwijk
SQL Server MVP
"frank" <frank@.discussions.microsoft.com> wrote in message
news:0F31A8AC-2918-44D6-B1DF-1AAE9871181A@.microsoft.com...
>I want to restore sql 2000 database to another server
> I have already backup it up on server-a(the ortginal sql server)use sql
> backup tool. I assume that the next steps is copy this file from server-a
> to
> server-b(the new server) stop sql services on server-b and start restore
> using the sql tool. Is this correct? or are they other steps I need to
> take?
>
> Thanks
>
|||You don't need to stop the SQL Server service.
Copy the file from server-a to server-b
Restore using either the Enterprise Manager or via Query Analyzer (my
preference)
You will also need to clean up your user and role information in the
restored db.
"frank" <frank@.discussions.microsoft.com> wrote in message
news:0F31A8AC-2918-44D6-B1DF-1AAE9871181A@.microsoft.com...
> I want to restore sql 2000 database to another server
> I have already backup it up on server-a(the ortginal sql server)use sql
> backup tool. I assume that the next steps is copy this file from server-a
to
> server-b(the new server) stop sql services on server-b and start restore
> using the sql tool. Is this correct? or are they other steps I need to
take?
>
> Thanks
>
|||I do not want to move the database I just want to restore to another server
if possible with never sql down.
"Jacco Schalkwijk" wrote:

> http://support.microsoft.com/default...;en-us;Q314546
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "frank" <frank@.discussions.microsoft.com> wrote in message
> news:0F31A8AC-2918-44D6-B1DF-1AAE9871181A@.microsoft.com...
>
>
|||How did you backup the database? If you used SQL's BACKUP command or used
Enterprise Manager then the service on the target server has to be running
in order to restore it. If you are replacing an existing DB of the same name
then you need to use the REPLACE option on the RESTORE command (be very sure
you want to do this!).
If you backed-up the database file itself rather than use SQL's native
backup then just restore the file(s) to the target server and use
sp_attach_db to attach them. Again, no need to shut down the service.
David Portas
SQL Server MVP
|||Just make backup of your database and follow the steps outlined in that
article. It doesn't mean you have to delete the database from the original
server after you have made a backup of it. That article just covers
everything you need to think of when either moving or copying databases
between servers.
Jacco Schalkwijk
SQL Server MVP
"frank" <frank@.discussions.microsoft.com> wrote in message
news:9F594C56-821F-4160-8689-6606A37E9F6B@.microsoft.com...[vbcol=seagreen]
>I do not want to move the database I just want to restore to another server
> if possible with never sql down.
>
> "Jacco Schalkwijk" wrote:

restore slq database to another server

I want to restore sql 2000 database to another server
I have already backup it up on server-a(the ortginal sql server)use sql
backup tool. I assume that the next steps is copy this file from server-a to
server-b(the new server) stop sql services on server-b and start restore
using the sql tool. Is this correct? or are they other steps I need to take?
Thankshttp://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546
--
Jacco Schalkwijk
SQL Server MVP
"frank" <frank@.discussions.microsoft.com> wrote in message
news:0F31A8AC-2918-44D6-B1DF-1AAE9871181A@.microsoft.com...
>I want to restore sql 2000 database to another server
> I have already backup it up on server-a(the ortginal sql server)use sql
> backup tool. I assume that the next steps is copy this file from server-a
> to
> server-b(the new server) stop sql services on server-b and start restore
> using the sql tool. Is this correct? or are they other steps I need to
> take?
>
> Thanks
>|||You don't need to stop the SQL Server service.
Copy the file from server-a to server-b
Restore using either the Enterprise Manager or via Query Analyzer (my
preference)
You will also need to clean up your user and role information in the
restored db.
"frank" <frank@.discussions.microsoft.com> wrote in message
news:0F31A8AC-2918-44D6-B1DF-1AAE9871181A@.microsoft.com...
> I want to restore sql 2000 database to another server
> I have already backup it up on server-a(the ortginal sql server)use sql
> backup tool. I assume that the next steps is copy this file from server-a
to
> server-b(the new server) stop sql services on server-b and start restore
> using the sql tool. Is this correct? or are they other steps I need to
take?
>
> Thanks
>|||I do not want to move the database I just want to restore to another server
if possible with never sql down.
"Jacco Schalkwijk" wrote:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "frank" <frank@.discussions.microsoft.com> wrote in message
> news:0F31A8AC-2918-44D6-B1DF-1AAE9871181A@.microsoft.com...
> >I want to restore sql 2000 database to another server
> > I have already backup it up on server-a(the ortginal sql server)use sql
> > backup tool. I assume that the next steps is copy this file from server-a
> > to
> > server-b(the new server) stop sql services on server-b and start restore
> > using the sql tool. Is this correct? or are they other steps I need to
> > take?
> >
> >
> > Thanks
> >
> >
>
>|||How did you backup the database? If you used SQL's BACKUP command or used
Enterprise Manager then the service on the target server has to be running
in order to restore it. If you are replacing an existing DB of the same name
then you need to use the REPLACE option on the RESTORE command (be very sure
you want to do this!).
If you backed-up the database file itself rather than use SQL's native
backup then just restore the file(s) to the target server and use
sp_attach_db to attach them. Again, no need to shut down the service.
--
David Portas
SQL Server MVP
--|||Just make backup of your database and follow the steps outlined in that
article. It doesn't mean you have to delete the database from the original
server after you have made a backup of it. That article just covers
everything you need to think of when either moving or copying databases
between servers.
--
Jacco Schalkwijk
SQL Server MVP
"frank" <frank@.discussions.microsoft.com> wrote in message
news:9F594C56-821F-4160-8689-6606A37E9F6B@.microsoft.com...
>I do not want to move the database I just want to restore to another server
> if possible with never sql down.
>
> "Jacco Schalkwijk" wrote:
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546
>> --
>> Jacco Schalkwijk
>> SQL Server MVP
>>
>> "frank" <frank@.discussions.microsoft.com> wrote in message
>> news:0F31A8AC-2918-44D6-B1DF-1AAE9871181A@.microsoft.com...
>> >I want to restore sql 2000 database to another server
>> > I have already backup it up on server-a(the ortginal sql server)use sql
>> > backup tool. I assume that the next steps is copy this file from
>> > server-a
>> > to
>> > server-b(the new server) stop sql services on server-b and start
>> > restore
>> > using the sql tool. Is this correct? or are they other steps I need to
>> > take?
>> >
>> >
>> > Thanks
>> >
>> >
>>