Server Maintenance

• VastSQL

  SSC-Dedicated

  Points: 36144

  More actions

  March 30, 2010 at 12:21 am

  #220470

  Hi Experts,

  We are having a server with four databases.Out of this one is more than 100GB.

  What will be the normal RAM usage ?We are having 4GB RAM and its showing 3.5GB usage?

  What is the normal log file size for a 100GB database?

  Now the database is in simple recovery mode and we planning to change to bulk logged to take log backups,any negative impact?

  Any recommendation on database backup as data is very important.

  How often can we run DBCC CHECKDB ?

  Thanks in Advance

• VastSQL

  SSC-Dedicated

  Points: 36144

  More actions

  March 30, 2010 at 12:36 am

  #1141969

  Adding to above

  Is it possible to append differential backup to a full backup?

• Suresh B.

  SSC-Insane

  Points: 22986

  More actions

  March 30, 2010 at 3:22 am

  #1142031

  Ratheesh.K.Nair (3/30/2010)

  ---

  Adding to above

  Is it possible to append differential backup to a full backup?

  Yes. It is possible to take a backup to existing backup file.

  However it is recommended to take backups to separate files.

  Standardize the backup process. Follow same process for all the databases on all the servers. Also document it.

• VastSQL

  SSC-Dedicated

  Points: 36144

  More actions

  March 30, 2010 at 4:12 am

  #1142045

  Thanks Suresh,

  Hope u meant that differential backup and full backup can be appended to the same file.

• Suresh B.

  SSC-Insane

  Points: 22986

  More actions

  March 30, 2010 at 5:48 am

  #1142084

  Ratheesh.K.Nair (3/30/2010)

  ---

  Thanks Suresh,

  Hope u meant that differential backup and full backup can be appended to the same file.

  Yes.

  Any (full or diff) backup can be appended to an existing backup file.

  For example:

  backup database db1 to disk = 'E:\MCITP\db1_diff.bak' with differential

  backup database db2 to disk = 'E:\MCITP\db1_diff.bak'

  restore database db2 from disk = 'E:\MCITP\db1_diff.bak' with file = 2, replace

  As I mentioned earlier it is not a best practice.

  BOL

  { NOINIT | INIT }

  Controls whether the backup operation appends to or overwrites the existing backup sets on the backup media. The default is to append to the most recent backup set on the media (NOINIT).