SQL Server Performance Forum – Threads Archive
Converting DB to Filegroup
Hello Every, I am planning to convert my database into filegroup.Right now my DB size is 79GB and have only one primary mdf file. I want to add one more, so that my DB performance can improve.but before i go i have few question in my mind. 1). forming filegroup is really going to improve the performance of DB 2). Usually after adding new file, sometime i came across database went into suspect mode 3). How to design Backup and Recovery Plan Please provide your inputs. thanks and Regards
Ravi Kumar
check this
http://www.sql-server-performance.com/ac_filegroup_performance.asp
quote:Originally posted by SQL2000DBA
Hello Every,
I am planning to convert my database into filegroup.Right now my DB size is 79GB and have only one primary mdf file. I want to add one more, so that my DB performance can improve.
but before i go i have few question in my mind. 1). forming filegroup is really going to improve the performance of DB 2). Usually after adding new file, sometime i came across database went into suspect mode 3). How to design Backup and Recovery Plan Please provide your inputs. thanks and Regards
Ravi Kumar
but before i go i have few question in my mind. 1). forming filegroup is really going to improve the performance of DB 2). Usually after adding new file, sometime i came across database went into suspect mode 3). How to design Backup and Recovery Plan Please provide your inputs. thanks and Regards
Ravi Kumar
1) You will definetly have the performance gain by adhereing to the tips listed in Dinesh’s link. 2) If the database goes to suspect mode then check the location of additional file disk has required free space to go. 3) You can continue taking full database backup which will take care of all the files in the database. For more information refer to the books online for FILE Backups topic also. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>