Error deleting Web site . You can't delete a site that has subssites

Error Description : When we try to delete ( From site settings wizard) a sharepoint site ( Not a site collection) which has some sub sites created under it, we get following error message :

Error deleting Web site . You can't delete a site that has subssites

Stsadm -o deleteweb command too doesn't delete such sites and throws the same error.

Solution : Try following steps from site settings to delete such sites:

• Site Actions -> Site Settings
• Site Administration: Content and Structure
• In the left column, move to the parent of the main site to be deleted
• In the right column, choose the site to be deleted (YourSite in our example)
• Menu: Actions -> Delete
• Deleting the selected sites will permanently delete all content and user information. All subsites in this site will also be permanently lost. Do you want to continue?: OK

Hope this will help. ;-)

Not able to create New Site Collection in Moss 2007- Unknown Error

Issue:

Today I came across a new problem in My Moss 2007 enviornment.
When I tried to create a site collection under a Web application I received following error..

"A runtime exception was detected. Details follow. Message: The transaction log for database 'XX_DB' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases.

Reason:

When I looked deep in to the issue and checked the SQL logs I found that in the SQL error logs too.. there were N number of errors saying "The transaction log for database 'SharePoint_Config' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases"

When checked the siae of LDF file of Transaction database it was more than 5 GB in comparision to 600 MB of MDF file.

So, when Transation Log file of any data base becomes full , it does not allow to perform any operation on database. And so was the case with the Sharepoint_config database , It was not allowing to perform any action on it until the LDF files is made with some free space.

It did not allow to back up the database as well as backup also requires to write some transactions in Transaction log and it was already full.

Resolution:

I performed following steps to decrease the size of  Transaction log of sharepoint_config database:

1. To be on sager side took backup of Transation log with following SQL Query:
   
   BACKUP LOG Sharepoint_Config TO DISK='D:\SP Backup\SPconfigLogBackup.bak'
   GO
 
2. Now Shrank the Transaction log file to create space on disk and make the space in Transation log file as
    well with following SQL Query

 USE SharePoint_Config
 BACKUP LOG Sharepoint_Config WITH TRUNCATE_ONLY
 DBCC SHRINKFILE (N'SharePoint_Config_log' , 200)
 GO

After issuing these two Queries, I found that the size of LDF file of sharepoint_Confing database was reduced to 200 MB and I could take the backup of database too.

Once the transation log file was emptied, I was able to create the site collection again.

Hope this will help you guys...

Welcome to My Blog

Hello Friends,
I have come up with my new blog.
Lets make it little more interesting this time ;-)

Lalit