SQL Server Performance Forum – Threads Archive
Partial backup of Read-Only database
Hi All, As per the microsoft document the partial backup of Read-Only databases will take only the backup of primary file group. but when i test in one of my test servers i could backup the whole database and restore the same. So i was confused about that.Also the partial backup is taking the same amount of time as the full backup of READ-ONLY databases. i created a database test_bk with 3 filegroupsi tried all the other options in partial backup and are working fine.
but i could’nt understand why the whole database is backed up when i partial backup the read-only database. Can anyone help me out.. Your thoughts will be valuable.
Thanks in advance. Regards,
Rajesh.
rajesh
Obviously, partial backups only work if you have a database with filegroups in the first place, so if you don’t have such an arrangement you may want to think about re-segregating your data into filegroups first. As a general rule, data should be segregated into different filegroups whenever possible for the best possible parallelization. Have you checked the contents of that partial backup? Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
Hi Satya, As i have mentioned earlier i created a database with 3 file groups one primary and 2 secondary
filegroups and made the database as readonly. Also i have checked the whole content and i can restore the whole database.
So i could’nt find the use of partial backup.
Rajesh. rajesh
Check with RESTORE FILELISTONLY and tell what you see.
Ensure the source database was in READONLY mode. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
I could find all the filegroups listed in the resultset with sizes.
please help me …….. rajesh
Satya, Thanks for you help.
For some strange reason when i tested from scrach i could backup only the primary filegroup of a read only database. i do’nt know where i went wrong. Will be in touch.
Cheers Raj. rajesh
Even that stumped me earlier, so thats why I was asking whether the database is READONLy or not. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
]]>