Re: VLDB backups and partial restore
From: Don Ferguson (don_at_nospamplease)
Date: 08/30/04
- Next message: Mingqing Cheng [MSFT]: "RE: SQL Agent not starting"
- Previous message: Uri Dimant: "Re: SQL Data Transfer"
- In reply to: Pankaj Agarwal [MSFT]: "RE: VLDB backups and partial restore"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 29 Aug 2004 22:18:22 -0700
You may want to consider creating another database for your operational
tables on the same server. You would then need to repoint the the
application to the new database for these tables or create a view.
"Pankaj Agarwal [MSFT]" <pankaja@online.microsoft.com> wrote in message
news:mcum7ruhEHA.304@cpmsftngxa10.phx.gbl...
> Hello Michael
>
> You would need to implement a manual solution possibly involving DTS/BCP
> to
> another staging database, unless you can find a third party tool that lets
> you do what you are looking for here. SQL Server Filegroup backup restore
> functionality will not work for you in this situation.
>
> Thank you for using Microsoft newsgroups.
>
> Sincerely
>
> Pankaj Agarwal
> Microsoft Corporation
>
> This posting is provided AS IS with no warranties, and confers no rights.
>
- Next message: Mingqing Cheng [MSFT]: "RE: SQL Agent not starting"
- Previous message: Uri Dimant: "Re: SQL Data Transfer"
- In reply to: Pankaj Agarwal [MSFT]: "RE: VLDB backups and partial restore"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|