March 16, 2012 at 3:59 am
Do I take backup of a single schema of a database in sql server?
March 16, 2012 at 4:10 am
Do you? I dont know.
Should you? You should always keep a sources controlled copy of your database schema. Ideally down to the object level with developers working from source control rather than the database itself.
March 16, 2012 at 4:16 am
Backups in SQL Server are at a database, filegroup or file level, not schema. A schema is a logical grouping of objects, doesn't necessarily match to a phyical grouping in file or filegroup
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 16, 2012 at 4:29 am
GilaMonster (3/16/2012)
Backups in SQL Server are at a database, filegroup or file level, not schema. A schema is a logical grouping of objects, doesn't necessarily match to a phyical grouping in file or filegroup
Hmm never read it that way. Not the best wording.
March 16, 2012 at 4:32 am
MysteryJimbo (3/16/2012)
Not the best wording.
Feel free to improve on it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 16, 2012 at 4:46 am
GilaMonster (3/16/2012)
MysteryJimbo (3/16/2012)
Not the best wording.Feel free to improve on it.
Meant the question
March 16, 2012 at 4:56 am
MysteryJimbo (3/16/2012)
GilaMonster (3/16/2012)
MysteryJimbo (3/16/2012)
Not the best wording.Feel free to improve on it.
Meant the question
Ah. Looking at the OP's other questions (about file and filegroup backups), I'm guessing he's asking about backing up at a schema level, rather than backing up the database schema.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply