No announcements
Found 1552666 threads
-
0 VotesProblem with restore read_only filegroup
John Sansom, you are right, but in my example i try to restore read_only filegroups (B1 and B2) and i don't changed this.Answered | 7 Replies | 7362 Views | Created by greendraw - Tuesday, July 12, 2011 8:32 AM | Last reply by John Sansom - Wednesday, July 13, 2011 7:22 AM
-
0 Votes
FileGroup restore
We restored production backup file on Developement server.Answered | 2 Replies | 1226 Views | Created by Raja Chikkala - Sunday, September 28, 2014 7:46 PM | Last reply by Kalman Toth - Sunday, September 28, 2014 11:45 PM -
0 Votes
Restore of filegroup to development database
Hello, Just as an FYI - all filegroups are contained in a full database backup.Answered | 3 Replies | 2364 Views | Created by Andrew Pruski - Tuesday, June 25, 2013 2:39 PM | Last reply by Andrew Pruski - Thursday, June 27, 2013 11:08 AM -
0 Votes
restore from file/filegroup
2) also if we looking for partial recovery of specific tables etc (2nd point), how do we know that a table doesn't span across multiple files or filegroups and that it is ...Answered | 5 Replies | 966 Views | Created by vtpcnk - Tuesday, July 15, 2014 7:43 AM | Last reply by Andreas.Wolter - Wednesday, July 16, 2014 7:32 AM -
0 Votes
Move or Restore a Filegroup to a different database
You would also get into some interesting log consistency issues - to restore database B, you'd you'd have to start restoring from a full backup from ...Answered | 4 Replies | 8073 Views | Created by Sams007 - Thursday, January 29, 2009 11:34 PM | Last reply by Jim McLeod - Tuesday, November 17, 2009 11:13 PM -
7 Votes
Filegroup Restoration Post FG Restore Index Not reflecting
Basically, whener you restore file/filegroup of a database (as in this case) you need transaction log restores to synchronize to a point in time.Answered | 25 Replies | 1222 Views | Created by Manjunath C Bhat - Thursday, July 17, 2014 7:04 AM | Last reply by Erland Sommarskog - Monday, July 21, 2014 10:06 PM -
0 Votes
Read_Only and Read_Write File Groups in Same Database
Can you expand on your comment "A Read_Only filegroup don't have any performance advantage" thanksAnswered | 4 Replies | 1003 Views | Created by abeljda - Thursday, June 12, 2014 5:09 PM | Last reply by RAJU RG - Thursday, June 12, 2014 10:37 PM -
0 Votes
SQL Server Filegroup restores
Yes, I am getting this kind of error when I try to restore the filegroups.Answered | 4 Replies | 1123 Views | Created by Shyam Sunder Gajendra - Tuesday, February 10, 2015 12:32 AM | Last reply by Satish Kartan, MCITP - Wednesday, February 11, 2015 3:34 AM -
4 Votes
Filegroup Restore and error "The online restore to database 'DB' failed."
Was the problem resolved after performing our action plan steps?Answered | 8 Replies | 2119 Views | Created by FabrícioPJ - Monday, August 25, 2014 5:09 PM | Last reply by Lydia Zhang - Monday, September 8, 2014 9:21 AM -
0 Votes
A small problem in deleting a filegroup!
However, you cannot drop them because the filegroup holding the data was not restored.Answered | 5 Replies | 2441 Views | Created by Anish Tuladhar - Monday, July 16, 2012 5:51 AM | Last reply by Anish Tuladhar - Tuesday, July 17, 2012 7:57 AM -
0 Votes
Filegroup
How to: Back Up Files and Filegroups (Transact-SQL) How to: Restore Files and Filegroups ...Answered | 2 Replies | 1147 Views | Created by Surya.chamala - Monday, December 2, 2013 4:11 PM | Last reply by Shanky_621 - Monday, December 2, 2013 6:50 PM -
0 Votes
Is it possible to restore a Filegroup backup on a new DB
You need at least the primary filegroup (in addition to the one you want) since it contains all meta-data (internal system tables and such).Answered | 2 Replies | 1312 Views | Created by xXShanXx - Friday, March 21, 2014 11:52 AM | Last reply by TiborK - Tuesday, March 25, 2014 12:00 PM -
0 Votes
Do I need to restore all the filegroup backups
Have you restored all needed log backups?Answered | 5 Replies | 5061 Views | Created by Stan210 - Sunday, June 19, 2011 1:17 AM | Last reply by Naomi N - Sunday, June 19, 2011 7:32 AM -
0 Votes
Filegroups - are different backup/restore strategies possible?
Hi Menam, This error can occur for some reasons.For example,we have a filegroup with a damaged or missing data file, or we didn't restore the tail log.Answered | 4 Replies | 1840 Views | Created by menam - Wednesday, September 18, 2013 5:19 PM | Last reply by davidbaxterbrowne - Friday, September 20, 2013 5:07 PM -
0 Votes
"RESTORE LOG" works even if filegroup doesn't exist?
I mean, the filegroup is present on the database where the log backup is generated, but is missing where the log backup is restored.Answered | 7 Replies | 938 Views | Created by Marcos Moran - Monday, February 23, 2015 6:37 PM | Last reply by TiborK - Thursday, February 26, 2015 5:05 PM -
0 Votes
After Piecemeal Primary FileGroup Restoration, Database Property Window Shows other FileGroups also
The development database would still have the secondary fliegroup, when you restore from prod anew, you only need to restore the primary filegroup.Answered | 4 Replies | 1570 Views | Created by skan2dan - Sunday, March 9, 2014 11:32 AM | Last reply by skan2dan - Tuesday, April 8, 2014 6:00 AM -
0 Votes
Restore database preserving existing file/filegroup structure
The restore command will create the database first, with the same number of files (etc) as the original database (the one you took backup of).Answered | 3 Replies | 3114 Views | Created by Andrea Caldarone - Tuesday, April 24, 2012 9:02 AM | Last reply by Mohammad-Sufian - Tuesday, April 24, 2012 1:27 PM -
2 Votes
Creating Read_Only Database in SQL Azure?
he's probably referring to the ALTER DATABASE SET READ_ONLY option in SQL Server ALTER DATABASE AdventureWorks2012 SET ...Answered | 2 Replies | 5899 Views | Created by Mahesh Deshpande - Monday, April 9, 2012 1:56 AM | Last reply by JuneT - Tuesday, April 10, 2012 2:37 AM -
0 Votes
Filegroup Backups
If you question is to restore additional filegroup on top of the existing database which was already recovered, then there is no way.Answered | 1 Replies | 2078 Views | Created by sqlajnin - Thursday, May 23, 2013 7:06 PM | Last reply by Chirag Shah - Thursday, May 23, 2013 7:57 PM -
0 Votes
filegroup is full problem
If it has helped you to resolve the problem, please Mark it as Answer.Answered | 3 Replies | 6589 Views | Created by Grant Guan - Friday, February 25, 2011 9:46 AM | Last reply by TiborK - Saturday, February 26, 2011 4:48 PM - Items 1 to 20 of 1552666 Next ›
No announcements
