Re: SQL Database size excessively increasing after Site Collection Restore

This is a common issue not limited to SharePoint databases!

Sounds like you are using the full logged method and your maintenance
plan isn't setup correctly!

Also make sure you have the right service pack if you have sp2 for sql
server as there were a few releases of this...

If you never backup the log file it grows out of proportion!

Get a SQL Server DBA who knows what he is doing!

Regards,
Tom Bizannes
Microsft SharePoint and Sql Server Specialist
Sydney, Australia

.

Relevant Pages

  • Problems after moving Sharepoint databases to new SQL Server
    ... I have moved all my sharepoint databases to a new sql server according the ... technet article http://technet.microsoft.com/en-us/library/cc512723.aspx. ... The installation ends afterwards with login ...
    (microsoft.public.sharepoint.windowsservices)
  • SQL aliases are your friend
    ... I very strongly recommend that if you're using SQL Server 2005 with SharePoint, ... You setup an alias called, say, SQLAlias1, and point it to the SQL server which hosts your SharePoint databases, say SQLServer1\Instance1 ... you enter the database server as SQLAlias1 rather than SQLServer1\Instance1. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Problem with remove files older then in backup
    ... You should see a job that references your maintenance ... plan name. ... Jasper Smith (SQL Server MVP) ...
    (microsoft.public.sqlserver.server)
  • Re: Problem with remove files older then in backup
    ... You should see a job that references your maintenance ... plan name. ... Jasper Smith (SQL Server MVP) ...
    (microsoft.public.sqlserver.tools)
  • Re: Problem with remove files older then in backup
    ... You should see a job that references your maintenance ... plan name. ... Jasper Smith (SQL Server MVP) ...
    (microsoft.public.sqlserver.setup)
Loading