Unix Technical Forum

FILEGROUP BACKUP/RESTORE

This is a discussion on FILEGROUP BACKUP/RESTORE within the SQL Server forums, part of the Microsoft SQL Server category; --> Hi, I have a database were all the indexes are in a seperate filegroup a few large tables are ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > SQL Server

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-29-2008, 07:24 PM
raj.raghavan@gmail.com
 
Posts: n/a
Default FILEGROUP BACKUP/RESTORE

Hi,
I have a database were all the indexes are in a seperate filegroup a
few large tables are in a seperate filegroup. We take backup at
different times and I have backup of primary, two filegroup and then
transaction logs. The backup was successful when I restore the same
backup it is erroring out with this error:

Server: Msg 3135, Level 16, State 2, Line 1
The backup set in file 'E:\Manual Backup\test_primary.bak' was created
by BACKUP DATABASE...FILE=<name> and cannot be used for this restore
operation.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Server: Msg 3135, Level 16, State 2, Line 13
The backup set in file 'E:\Manual Backup\test_fgp1.bak' was created by
BACKUP DATABASE...FILE=<name> and cannot be used for this restore
operation.
Server: Msg 3013, Level 16, State 1, Line 13
RESTORE DATABASE is terminating abnormally.
Server: Msg 3135, Level 16, State 2, Line 21
The backup set in file 'E:\Manual Backup\test_fgp2.bak' was created by
BACKUP DATABASE...FILE=<name> and cannot be used for this restore
operation.
Server: Msg 3013, Level 16, State 1, Line 21
RESTORE DATABASE is terminating abnormally.

Thanks in advance
Raj

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 08:19 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com