Welcome to dbForumz.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Filegroup restore used to selectively refresh filegroup in..

  
   Database Forums (Home) -> Server RSS
Next:  How do I record the date of the first record entr..  
Author Message
CqlBoy

External


Since: May 14, 2010
Posts: 1



(Msg. 1) Posted: Fri May 14, 2010 9:16 am
Post subject: Filegroup restore used to selectively refresh filegroup in 2nd db.
Archived from groups: microsoft>public>sqlserver>server (more info?)
I have TestDB1 comprised of 5 filegroups, which I've completed full/log
backups to to restore as TestDB2. When data changes within one filegroup on
TestDB1, I've taken a diff' + tlog backup and tried to use it to restore on
TestDB2 so that same filegroup would be essentially refreshed. My execution
sequence uses the last full, last diff', and tlog from TestDB1 but this
doesn't work? Why? Is there a way to do this in SQL 2K8? Thx. -CqlBoy

Message applying full backup:
>Processed 16 pages for database 'FGTestRestore', file 'FGTest_fg2' on file 1.
>RESTORE DATABASE ... FILE=<name> successfully processed 16 pages in 0.026 >seconds (4.807 MB/sec).

Message applying diff' backup:
>Processed 16 pages for database 'FGTestRestore', file 'FGTest_fg2' on file 1.
>RESTORE DATABASE ... FILE=<name> successfully processed 16 pages in 0.020 >seconds (6.250 MB/sec).

Message applying diff' log backup:
>Msg 3116, Level 16, State 1, Line 2
>The supplied backup is not on the same recovery path as the database, and is >ineligible for use for an online file restore.
>Msg 3013, Level 16, State 1, Line 2
>RESTORE DATABASE is terminating abnormally.

 >> Stay informed about: Filegroup restore used to selectively refresh filegroup in.. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Filegroup Restore Szenario / db size problem [SQL 2K] - Hello, we have some databases which are so large that they we can not restore them on our test server, because its disk space is not enough. The main part or the size of the database is used by columns of type image. On the test server we don't need..

Removing a Filegroup - About 3 years ago we were getting index corruptions on our SQL server database. MS and SAP indicated it was a H/W problem but HP after performing a lot of tests suggested the problem was a S/W problem. So to get the problem resolved MS and SAP..

Delete on a single filegroup - I am running SQL 2005 SP2. I have a partitioned table and was wondering if there is a view that could tell me the data that resides on a specific filegroup. What I would like to do is to delete only the data that resides on a specific filegroup. Thx. -...

How to refresh Template Exlorer - Hello! I was wondering if there is a way to refresh template explorer in Management Studio. I was copying my old templates and the only way to refresh them I found it reopening Management Studio. I am kind of missing refresh feature from QA. ..

restore database - I trying to rrestore a database from BAK file and I get an error microsoft sql -dmo (odbc sqlstate:4200). device activation error the physical file *.ldf/*.mdf may be incorrect. what I am doing wrong. someone can help me. Thanks.
   Database Forums (Home) -> Server All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]