Sunday, February 12, 2012

Backup

I have backed up a sql server 2000 db to a BAK file called george.bak for
exapmle. I need to restore this databse into a another sqll server 2000.
How can i do this using enterprise manager or any method.I'd prefer doing such things by QA
exec SRV.master.dbo.sp_executesql N'RESTORE DATABASE pubs
FROM DISK =''C:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\testback.bak'''
Note : Take a look at RESTORE article in the BOL you 'll need probably use
WITH MOVE option
"George Schneider" <georgedschneider@.news.postalias> wrote in message
news:D2AE92DF-5D3F-40C5-ACFD-5E2F75AD9D11@.microsoft.com...
>I have backed up a sql server 2000 db to a BAK file called george.bak for
> exapmle. I need to restore this databse into a another sqll server 2000.
> How can i do this using enterprise manager or any method.|||Hello George,
You may want to refer to the following articles which shall address this
issue:
314546 HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/?id=314546
224071 INF: Moving SQL Server Databases to a New Location with Detach/Attach
http://support.microsoft.com/?id=224071
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
>From: "Uri Dimant" <urid@.iscar.co.il>
>References: <D2AE92DF-5D3F-40C5-ACFD-5E2F75AD9D11@.microsoft.com>
>Subject: Re: Backup
>Date: Sun, 22 Jan 2006 10:23:56 +0200
>Lines: 21
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>Message-ID: <uZ2Zx0yHGHA.2040@.TK2MSFTNGP14.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: bzq-25-106-78.cust.bezeqint.net 212.25.106.78
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:418437
>X-Tomcat-NG: microsoft.public.sqlserver.server
>I'd prefer doing such things by QA
>
>exec SRV.master.dbo.sp_executesql N'RESTORE DATABASE pubs
>FROM DISK =''C:\Program Files\Microsoft SQL
>Server\MSSQL\BACKUP\testback.bak'''
>
>Note : Take a look at RESTORE article in the BOL you 'll need probably
use
>WITH MOVE option
>
>
>"George Schneider" <georgedschneider@.news.postalias> wrote in message
>news:D2AE92DF-5D3F-40C5-ACFD-5E2F75AD9D11@.microsoft.com...
>>I have backed up a sql server 2000 db to a BAK file called george.bak for
>> exapmle. I need to restore this databse into a another sqll server 2000.
>> How can i do this using enterprise manager or any method.
>
>

No comments:

Post a Comment