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
>> >
>> >
>>

restore single table from backup

Hi,
I'm looking for tool that would allow me to restore a single table from a ba
ckup without restoring full database... I tried lumigent software but it did
not work as I expected...
Thank you for your help
Darekhi derek,
Im not sure about 3rd party tool. but with SQL Server, you can not restore a
single table out of backup. You can restore the database to a different SQL
Server, or if you are using same Server, then restore it with the different
database name and transfer the required table using DTS/bcp etc to destinati
on.
-- Vishal|||Read a while ago that CA has a tool to do this among others. You may check
with them. Of course in restoring a table (if you can) you always need to
watch out data integrity issues.
"Darek" <anonymous@.discussions.microsoft.com> wrote in message
news:CD4CFA7D-85A3-4D71-8524-EB3834C92123@.microsoft.com...

quote:

---

> Hi,
> I'm looking for tool that would allow me to restore a single table from a

---

backup without restoring full database... I tried lumigent software but it
did not work as I expected...

quote:

---

> Thank you for your help
> Darek

---

|||Hi,
SQL server versions which is higher than 6.5 will not support table level
restore, Only Filegroup / full database restore is available in SQL 7 and
2000.
Thanks
Hari
MCDBA
"Darek" <anonymous@.discussions.microsoft.com> wrote in message
news:CD4CFA7D-85A3-4D71-8524-EB3834C92123@.microsoft.com...

quote:

---

> Hi,
> I'm looking for tool that would allow me to restore a single table from a

---

backup without restoring full database... I tried lumigent software but it
did not work as I expected...

quote:

---

> Thank you for your help
> Darek

---

sql