January 5, 2007 at 10:03 am
I have a production 24x7 database with a single 50GB MDF. I want to back it up and restore a copy of it on a different server as a read-only database with a single MDF (10GB) and multiple NDF datafiles (5 x 10GB). I need to be able to restore transaction log backups from the original database to the restored, read-only database every 15 minutes. The production database cannot be taken offline during the processes. Any help would be appreciated.
AgainstTheWall
January 5, 2007 at 12:48 pm
It can't be done with the restore database command. Oney way to do something like that would be to create the multiple file db and then bulk load/dts all of the data/tables/etc.. into it.
Tom
January 6, 2007 at 2:21 am
In backup or restore you can't do this...
You can restore same as production with 50 gb file then...create new filegroups in the restored database and move the tables to new filegroups by creating the clustered indexes on new filegroups .
Then shrink the first 50 GB file...
MohammedU
Microsoft SQL Server MVP
January 6, 2007 at 11:10 am
It seems that you should use log-shipping.
January 6, 2007 at 4:36 pm
I think its easy enough to change your filegroups around after the initial restore, though I would ask why? I typically only use filegroups if I cant fit all the data on the drive, or in extreme cases for performance - but I avoid when I can to keep maintenance simple, no worries about one filegroup filing up and another only used slightly.
Don't think log shipping is to going to satisfy your needs. Replication might be worth considering, as well as snapshots in 2005 (but I'd lean towards replication)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply