restore slq database to another server  
Author Message
qcope





PostPosted: Fri Jan 07 09:36:35 CST 2005 Top

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

SQL Server146  
 
 
Jacco





PostPosted: Fri Jan 07 09:36:35 CST 2005 Top

SQL Server >> restore slq database to another server http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546

--
Jacco Schalkwijk
SQL Server MVP




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


 
 
Armando





PostPosted: Fri Jan 07 09:41:00 CST 2005 Top

SQL Server >> restore slq database to another server 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.



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


 
 
frank





PostPosted: Fri Jan 07 09:45:03 CST 2005 Top

SQL Server >> restore slq database to another server I do not want to move the database I just want to restore to another server
if possible with never sql down.





> http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546
>
> --
> Jacco Schalkwijk
> SQL Server MVP
>
>


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





PostPosted: Fri Jan 07 09:50:59 CST 2005 Top

SQL Server >> restore slq database to another server 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
--


 
 
Jacco





PostPosted: Fri Jan 07 09:56:51 CST 2005 Top

SQL Server >> restore slq database to another server 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




>I do not want to move the database I just want to restore to another server
> if possible with never sql down.
>
>
>

>
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546
>>
>> --
>> Jacco Schalkwijk
>> SQL Server MVP
>>
>>


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