.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Shrinking the MSDB logs

Posted By:      Posted Date: October 02, 2010    Points: 0   Category :Sql Server

the MSDB log is about 15 GB whereas the data file is only 6 GB. Is there a way to shrink the MSDB log?


View Complete Post

More Related Resource Links

Toolbox: Database Audit Logs, Joel on Software, Code Handouts, and More


This month the Toolbox column takes a look at database logging, Joel Spolsky's blog, printing code projects, and ASP.NET reading.

Scott Mitchell

MSDN Magazine May 2008

Toolbox: Generate Office Documents, Monitor Event Logs, and More


Most data-driven Web sites are used as interfaces to collect, process, and summarize information. Reports that summarize the data can be presented to the user in a variety of formats-the most common way is to display the report directly in a Web page.

Scott Mitchell

MSDN Magazine June 2006

Office: Relive the Moment by Searching Your IM Logs with Custom Research Services


Often, IM conversations contain important information you'd like to keep and reuse. Fortunately, MSN Messenger 6.2 has a feature to keep a conversation history permanently in XML format. This article shows you how to leverage that conversation history by consolidating IM exchanges so they are indexed, searchable, and ultimately reusable using the Microsoft Office 2003 Research and Reference task pane.

John R. Durant

MSDN Magazine February 2005

getting a email delivert status when sending email using msdb.dbo.sp_send_dbmail


Hi All,

Can some help me regarding following.

I have set a job in sql server 2008 to send reminder emails for product expiration.
Now I want a report which will specify the list of the emails sent with the email status details like queued ,sent,delivered, failed.

I can fetch the emails that are sent by querying the like following

select * from sysmail_mailitems SM inner join sysmail_profile SP on SM.Profile_Id = SP.Profile_Id
and SP.Name ='ReminderProfile'

The problem is only getting a perfect status of email whether it is delived or failed. How I can get those status ?
Please help.


"Content for this URL is excluded by the server because a no-index attribute." in crawl logs


Hi All,

I am getting following error message in Crawl Logs

" Content for this URL is excluded by the server because a no-index attribute. "

Any help in this regard will be greatly appreciated.



'There is no Web named' in logs


I was wondering if anybody could help me.  When i look at logs in C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\LOGS i get a lot of errors saying 'There is no Web named'.

For example:-
09/08/2008 09:29:37.17  w3wp.exe (0x1BA0)                        0x296C Windows SharePoint Services    General                        8kh7 High     There is no Web named "/quality/Audit Reports/Forms/AllItems.aspx". 

There are no errors in server application event log.  I was hoping to find out what this means and if i should worry about the errors. 


Chris Rees.

Sharing folders under 12\logs


Hi Admins, 

I have a general question.  developer team does not have direct access to server. But they frequently need to dig logs for errors. (yes we have a test server but when switched to prod. environment, programs sometimes give errors that are need to be digged in prod)

Is it ok to "share" the folder program files\common files\microsoft shared\web server extensions\12\logs folder, so they can map the Web front End's logs folder to their computers ?

I dont really think it sounds good to make a sharing on production server like this,it is a sort of customization, I need your advices. is there a significant disadvantage that causes "don't!!" for this kind of operation?


Thanks in advance..


Re-run WSS 3.0 Usage Analysis Logs


WSS3.0SP2, 64-bit.

The service which runs and collects the log files for the Usage Analysis report was disabled for some reason. We have it re-activated but the logs for when it was down were not processed. How do we re-process those older logs?

Previously asked at  http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?&lang=&cr=&guid=&sloc=en-us&dg=microsoft.public.sharepoint.windowsservices&p=1&tid=f676c989-a369-4761-94e7-ef9b1c28fde7 and referred to here.

SQL Server Logs too big under Management

Hi, The sqlserver logs ("Current - date","Archive-date"...) is too big to open easily (esp at the time of crisis). Any idea how can I restrict the size of these logs to manageable size so that they can be read immediately? Is there any way to Archive daily logs separately? Thanks Chander

Shrinking the data file

Hi, I have a few doubts regarding database shrink. I have automated jobs that purge data from 3 or 4 tables every month. I would like to understand what would be the best way to reclaim disk space. I know shrinking the data file is not the best approach . i want to know if shrinking the data file once a month is acceptable. I know shrinking of the datafile leads to index fragmentation. So can i say rebuilding/Reorganizing indexes after the shrink operation is a safe approach.  Are there any safe approaches to avoid disk space issues? Thanks    

Sharepoint and IIS/Windows Event Logs in a single view

Hi - I'm coinsidering addng sharepoint log reading capabilities into an application I've built for reading windows and IIS logs (for more info http://logenvy.com). I know there are quite a few applications capable of reading sharepoint logs (a number are listed here http://stackoverflow.com/questions/781179/sharepoint-2007-log-viewer). Does anyone think the capability to analyse windows and IIS logs alongside sharepoint logs would be useful, or have any logging requirements not well met by the current set of tools? I'm especially keen to explore useful/interesting data visualizations on top of data logs.

SQLServerAgent could not be started (reason: Startup error: The 'msdb' database does not exist)

After installing Service pack 3 for Microsoft SQL Server 2005 the SQLServerAgent wont start: From SQLAGENT.OUT: 2010-08-30 17:10:08 - ! [298] SQLServer Error: 208, Invalid object name 'sys.configurations'. [SQLSTATE 42S02] (DisableAgentXPs) 2010-08-30 17:10:08 - ! [298] SQLServer Error: 208, Invalid object name 'master.dbo.sysdatabases'. [SQLSTATE 42S02] 2010-08-30 17:10:08 - ! [000] Startup error: The 'msdb' database does not exist 2010-08-30 17:10:08 - ! [298] SQLServer Error: 208, Invalid object name 'sys.configurations'. [SQLSTATE 42S02] (DisableAgentXPs) 2010-08-30 17:10:08 - ? [098] SQLServerAgent terminated (normally)

The SELECT permission was denied on the object 'sysjobs_view', database 'msdb', schema 'dbo'.

So, I have an SSIS package that uses a transfer jobs task between Server A and Server B.  When I run the package with my credentials, everything works fine.  However, when I run the package from an SSIS using a different user, I get the following error: Date 9/1/2010 8:00:00 AM Log Job History (xxx) Step ID 1 Server xxx Job Name xxx Step Name Run SSIS Duration 00:00:01 Sql Severity 0 Sql Message ID 0 Operator Emailed Operator Net sent Operator Paged Retries Attempted 0 Message Microsoft (R) SQL Server Execute Package Utility Version 10.0.2531.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:00:00 AM Error: 2010-09-01 08:00:01.39 Code: 0xC002F325 Source: Transfer Jobs Task Transfer Jobs Task Description: Execution failed with the following error: "An exception occurred while executing a Transact-SQL statement or batch.". End Error Error: 2010-09-01 08:00:01.39 Code: 0xC002F325 Source: Transfer Jobs Task Transfer Jobs Task Description: Execution failed with the following error: "The SELECT permission was denied on the object 'sysjobs_view', database 'msdb', schema 'dbo'.". End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 8:00:00 AM Finished: 8:00:01 AM Elapsed: 0.75 seconds The strange thing is, the user running the job ahs sysadmin permissions

Failed to initialize MSDB database for tuning (exit code: -1073741819). (DTAClient)

Hello,This is the first time I am using this forum. I am stuck and need some help. I received this error message both on SQL 2005 and 2008. I am currently using SQL 2008 DEV for testing purposes and I am experiencing this error message when trying to connect to Database Engine Tuning Advisor. I am using the SA account so I should not have any security issues. Also this is a fresh install of SQL 2008 DEV on a fresh install of Windows XP Pro with all SP. Can some please help.Error:"Failed to initialize MSDB database for tuning (exit code: -1073741819). (DTAClient)"=================================== Failed to open a new connection. =================================== Failed to initialize MSDB database for tuning (exit code: -1073741819). (DTAClient) ------------------------------Program Location:    at Microsoft.SqlServer.Management.DTA.Client.TuningServer.InitializeTuningParametersDatabase()   at Microsoft.SqlServer.Management.DTA.Client.TuningServer.InitializeConnection()   at Microsoft.SqlServer.Management.DTA.Client.TuningServer.Connect()   at Microsoft.SqlServer.Management.DTA.Shell.SessionMonitor.AddServerInternal(SqlConnectionInfo connectionInfo, SqlConnection connection)   at Microsoft.SqlServer.Management.DTA.Shell.SessionMonitor.AddServer(SqlConnectionInfo connectionInfo, SqlConnection connection)   at Microsoft.SqlServer.Management.DTA.Shell.SessionMonitor.On

Logs are written only on one WFE

Hi,h I have a four server farm. 1 db server and 3 wfe's. They are not load balanced. the log level is  "verbose".. however, only one wfe is writing logs. I mean, on the first WFE there are 3 log files under 12\logs and there are about 100 gb each. The other WFEs have three logs but they are 10kb  !!! Is this normal?? Why is that happening

Effect of error logs

Hi, I just came across a situtation where one of my application is trying to connect SQL box and is failing because of permission. It is writing audit failure to the Error log file. Can anyone please explain what would be the effect of this continous writing to error log. Does it affect performance of SQL Server in any ways or if there is a way i can check.Regards, Deven ----------------------------------------- Please vote if you find any of my post helpful.

Last_Backup_File is Null in msdb.dbo.log_shipping_monitor_primary

Hi There,I have log shipping setup for a SQL Server 2005 x64 SP2 Ent. Ed. database using a monitor server. I restored the database on the secondary server myself and synched it with primary before setting up log shipping. I don't have any issues with Log shipping, the tx log is backed up, copied over to the secondary and restored. However, last_backup_file, last_backup_date and last_backup_date_utc columns in log_shipping_monitor_primary table are all Null. I checked the log_shipping_monitor_secondary table and it shows the correct and updated information for last_copied_* and last_restored_* columns. I tried running sp_refresh_log_shipping_monitor with @agent_type=0 on primary with @mode as both 1 & 2 but it did not help in any way. I deleted the log shipping and set it up again from scratch but the same issue remains. I have 8 other databases using that monitor server but they do not have this issue. The only difference being that the rest of databases are on 32 bit Std Edition. Does anyone has any idea on how to resolve this? Basically, I need the last_Backup_file to ftp the logs to our backup center. Thanks!
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend