Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Multiple Database or 1 DB with logical broken up by Filegroups? Expand / Collapse
Posted Thursday, April 30, 2009 8:22 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, January 29, 2010 7:13 AM
Points: 7, Visits: 33
I am fairly new to SQL Server, and an IBM DB2 DBA by training. We are implementing a new project here at work and I am curious about this.

Our Legacy System has 13 databases broken up into logical business areas. In no situation do we have R/I spanning between databases. The R/I is contained within each database. This gives us the ability to back up each business area at a time that is most convenient for that business group. This also gives us 13 separate recovery areas, so if we lose one, we can restore it while the other 12 are up and running.

I have been told that in SQL Server, we can and should do all of this with 1 database. (by a someone here at work.) They said we can separate filegroups by schema. They also said we would be able to back up and recover each individual business unit by each file group and no affect to the rest of the data within the database.

I want to confirm that is infact a good Idea. Are their short comings to this approach? Any reason we would not want to do this?
Post #707716
Posted Friday, May 1, 2009 3:19 PM



Group: General Forum Members
Last Login: Today @ 5:43 PM
Points: 23,516, Visits: 37,735
Now triple posted. Please reply here.

Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #708799
Posted Friday, May 1, 2009 3:47 PM



Group: Administrators
Last Login: Today @ 1:59 PM
Points: 34,363, Visits: 18,582
Closing thread

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #708808
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse