Posts

Showing posts from March, 2013

How to Alter a SQL Server Database as Single User Mode and as Multi User Mode

Image
To alter the database state to restrict the access to the single user mode, first open the Microsoft SQL Server Management Studio, and connect to a SQL Server instance. Open the list of available databases belonging to the related instance in the Object Explorer window. Right click on the SQL Server database that you want to set its mode to single user and select Properties in the context menu. When you click properties menu item, the following Database Properties screen will be displayed for the selected database. I used database named Works for samples used for the article. Select the Options page from the list in the left side of the screen. If you scroll down the options list for State options, you will see Restrict Access database options with three options listed in the combo box. Restrict Access modes : Multiple, Single and Restricted modes . If you select Single mode and click the OK button, you can either alter the database access mode to single user successfully or you w

Shrink the truncated log file on SQL Server

USE  [DatabaseName] ; GO -- Truncate the log by changing the database recovery model to SIMPLE. ALTER DATABASE [DatabaseName] SET RECOVERY SIMPLE WITH NO_WAIT ; GO -- Shrink the truncated log file to 1 MB. DBCC SHRINKFILE ( DatabaseName_log , 1 ); --file_name is the logical name of the file to be shrink GO -- Reset the database recovery model. ALTER DATABASE [DatabaseName] SET RECOVERY FULL WITH NO_WAIT ; GO

All checked out documents for site collection

Image
List of all checked out documents not just Checked Out To me Steps ( MOSS only ) : 1. Navigate to Home > View All Site Content > Content and Structures Reports > Create a new report with following CAML Query <Where><Geq><FieldRef Name="CheckoutUser" LookupId="TRUE"/><Value Type="int">0</Value></Geq></Where> 2. Navigate to Site Action > Manage Content and Structure > Change the view to All Checked Out documents ( from right side view drop down)

Increase the SharePoint 2010 Upload File Size Limit

Image
The Problem. For teamsites and collaborations, sometimes it can be useful to upload big file size documents – which is allowed only partially by SharePoint and IIS. They both have different default settings for the maximum upload file size of a single document or file. They are: SharePoint Server 2010: 50 MB IIS7: ~30 MB So, when trying to upload a big document, this results in the following error: 85 MB is simply too much for the above mentioned settings. Now, the solution section will show you how to fix this. The Solution. The good news is: This can be custom tailored to your needs, by simply following 3 steps. Here comes the first step: 1. Increase the SharePoint Upload Limit via Central Administration First, you must increase the SharePoint 2010 upload limit. Central Administration “Manage Web Applications” Select desired web application row (don’t click on the title, just select) “General Settings” in the ribbon Under Maximum Upload Size, change the setting to