|
Home > Archive > MS SQL Server > February 2006 > SQL 2005 - Backup restore Q
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL 2005 - Backup restore Q
|
|
| rupart 2006-02-06, 3:23 am |
| Hello,
I have a database with multiple file groups and mdf(M:\) resides in
different disk and ldf(L:\) resides in different disk.
I dump all the backup to different disk (X:\).
Now, I am testing to restore the files.
When i choose "Retore Files and Filegroups" or "Restore Database" and
navigate to X:\, it just allow me to choose one file at a time. Isnt that it
should show the complete list?
How do i restore them completely?
| |
| John Bell 2006-02-06, 3:23 am |
| Hi
If you are doing file backups check out
http://msdn.microsoft.com/library/d...bkprst_9sab.asp
You will need to restore each file/transaction log backup separately.
John
"rupart" wrote:
> Hello,
> I have a database with multiple file groups and mdf(M:\) resides in
> different disk and ldf(L:\) resides in different disk.
> I dump all the backup to different disk (X:\).
> Now, I am testing to restore the files.
> When i choose "Retore Files and Filegroups" or "Restore Database" and
> navigate to X:\, it just allow me to choose one file at a time. Isnt that it
> should show the complete list?
> How do i restore them completely?
| |
| rupart 2006-02-06, 9:23 am |
| hi,
does this applies to SQL 2005 as well exactly? Any changes in syntax,
methods or whatsoever?
TIA
"rupart" wrote:
> Hello,
> I have a database with multiple file groups and mdf(M:\) resides in
> different disk and ldf(L:\) resides in different disk.
> I dump all the backup to different disk (X:\).
> Now, I am testing to restore the files.
> When i choose "Retore Files and Filegroups" or "Restore Database" and
> navigate to X:\, it just allow me to choose one file at a time. Isnt that it
> should show the complete list?
> How do i restore them completely?
| |
| John Bell 2006-02-11, 11:23 am |
| The same method will work with SQL 2005, you can download SQL Server 2005
books online from http://tinyurl.com/apt5z and check any commands for
compatibility.
John
"rupart" <rupart@discussions.microsoft.com> wrote in message
news:749C81B9-8AE5-4761-A915- 05D3EBBB3C99@microso
ft.com...[color=darkred]
> hi,
> does this applies to SQL 2005 as well exactly? Any changes in syntax,
> methods or whatsoever?
> TIA
>
> "rupart" wrote:
>
|
|
|
|
|