Re: SQL Database size excessively increasing after Site Collection Restore

Is it the mdf file or the ldf file that is large. we had problem with our
log file (ldf) after a restore that caused the log file to grow to 50Gb but
the mdf file was only 2gb.
What was happening was that the Transaction log backup was not clearing up
the entries and we had to do some fancy footwork to fix it.
If it is the log file, let us now and I will give you the details on our
fix.

"Dandare00uk" <dan@xxxxxxxxxxxxxxxx> wrote in message
news:1193242027.012088.41750@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
We currently have a live WSS server in one of our offices. We do a
Site Collection Backup every night. In another office we have a DR WSS
server which we restore the Site Collection to every night. Everything
works fine on the WSS side, we can view the contents on the DR server
after the restore.

The problem we are having is that the SQL2005 database and log are
growing out of proportion to the database on our live WSS system.
Example
Live database is 2660MB, which we backup using stsadm
DR database on 1st restore is the same size
Next time the restore is performed it grows by approx 1.6Gb yet WSS
still thinks it's 2.6Gb.
Each time we restore the database gets larger. We even deleted the
contents database from the SharePoint Console but the SQL database
still remained the size it was.

Any ideas what is causing the database in SQL to be that much large in
or DR environment than in our Live environment.



.

Relevant Pages

  • Re: Crash Recovery
    ... In theory, if the logfile closely follow the backup of DATA.BAK, then you ... can make a backup of the log file, then restore the database with norecovery ... and finish with the restoration of the log file with recovery. ...
    (microsoft.public.access.adp.sqlserver)
  • Restore WSS sites after disaster
    ... I lost the system disk of a server with a couple of WSS ... The database files files were located on a different disk. ... It seems that in order to restore a WSS site (with stsadm -o restore etc. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Copying WSS to another Server
    ... > the data in sync I back the SQL databases up and restore them to the ... It already has WSS installed. ... Go to your virtual server settings and manage Content Databases. ... >> Server database backup/restore tools. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: SQL Database size excessively increasing after Site Collection Restore
    ... log file after a restore that caused the log file to grow to 50Gb but ... In another office we have a DR WSS ... server which we restore the Site Collection to every night. ... growing out of proportion to the database on our live WSS system. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Restore Issue: Restore Not Providing Options for Database server..
    ... No advice but can you say for the benefit of others who may have advice whether you are using WSS 2.0 or WSS 3.0. ... I'm running into a weird issue when trying to restore a site or even ... allow you to specify a new database server and database names. ...
    (microsoft.public.sharepoint.windowsservices)