.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

Reducing the SQL Server transaction log on the fly for production DB ?

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :
Hi All,
I'd like to know which is the best solution possible to reduce the SQL Server transaction log in the live production server without downtime ?
1. Database full backup - which should commit transaction log ? (like in Exchange Server ?)
2. executing the following T-SQL Script from SSMS manually during the production working hours ?
-- Otto R. Radke - http://ottoradke.com
-- Info: T-SQL script to shrink a database's transaction log. Just set the
-- database name below and run the script and it will shrink the
-- transaction log.
-- Update the line below with the name of the database who's transaction
-- log you want to shrink.

View Complete Post

More Related Resource Links

SQL Server Database Transaction

A transaction is a group of SQL commands executed together as a single component of work to be accomplished. If all of these commands succeed, then a transaction is committed - the changes to the data are made final. If any of the commands within a transaction fail, then the entire transaction is cancelled, or in SQL Server terms, the transaction will be rolled back.

Transactions are one of the things that keep your data safe, but they're not necessarily easy to understand. Here's some help:

Deploying custom Web Parts on SharePoint 2007 production server

I would like to develop a custom SharePoint 2007 Web Part for a client. Currently I'm using Visual Studio to deploy my solution to a test environment (since it's a SharePoint Project I choose just Build -> Deploy from the menu). What are the appropriate steps to deploy it to the production server?

I'd like keep it simple and safe (i.e. use the principle of least privilege). Therefore (if possible) avoid using stsadm, achieve this through web interface, or avoid using administrative rights.

Also, can I specify the scope of my Web Part, i.e. choose on which Web Application or Site Collection will it be installed?

Application_Error not firing on Production server.

 Hi, I am trying to setup my application on Production server. Whenever any error occurs, we are redirecting to a specific page in Application_Error Event in Global.asaxThe code in Application_Error Page_________________________________________ string _rawUrl = Request.RawUrl;if (_rawUrl.IndexOf(".aspx") == -1 && _rawUrl.IndexOf(".gif") == -1 && _rawUrl.IndexOf(".jpg") == -1){       string[] _arrRawURL = _rawUrl.Split('/');       Server.Transfer("~/UserHomePage/Default.aspx?UserProfile=" + _arrRawURL[_arrRawURL.Length - 1]);}  It is getting fired Locally. As it was not working, I tried the alternative as belowMade Custom Errors to On in Web.config. and in IIS, in Custom Errors section, under 404 Page I gave the ErrorPage file Name and written the above code. But still  it is not working.Kindly help me out!  Thanks in Advance. Chaitanya.

Development and Production Server software information for Sharepoint 2010 ??

Need to ask my IT Team to get me softwares for Development machines to write code / develop sites which we can give to end customers for deploying in their Sp2010 Production farm . W.r.t to that i have following questions : For Development , a) Which Windows Server 2008 OS version is sufficient - Standard , Enterprise , R2 ? b) Which SQL Server Version is sufficient ? c) Which VIsual studio version ? d) Which Sp2010 license version ?   From Production environment perspective , have following questions - a) What should be a recommendation to client for Production Server - Widows 2008Server sp2 or R2 ? SQL Server 2008 Server Sp2 or R2 ? Which is better and why ?  

Transaction Handling in SQL Server 2008

Hi there,        I am using .NET (C#) and sql server 2008 for my application, I am fetching records from a table and using gridview to show them.        Now saving selected records (using checkbox to select records) into another table row by row. before saving the records if records with same ID is present need to delete those records. could anyone tell me how to use transaction in SQL server 2008. any blog or website............... anything   Thanks, Sadaf

Doesn't restart sql server rollback uncommitted transaction?

hi, i executed a long-running sql in the management studio. The sql updates many rows and all updates are within a transaction. After runing 30 mins, the hard disk is full. That's because of the uncommitted updates. Then, i restarted the sql server because I thought after restarting, the uncommitted transaction is rollback and the occupied hard disk space is also released. But i found that the transaction is rollbacked but the hard disk space is not released. Why the hard disk space is not released? how can i release the disk space now? Thank you for your help.

Migrating to Production server

Hi All, We have a dev server in which we have two databases which we are maintaning for 3yrs.The tables in these databases have data for 3yrs like in millions. now we are planning to migrate it over  to production server.the dev  server will be with us but the whole databases and jobs and everything from dev server should be migrated to the new production server. can anyone guide me the step by step process how to migrate the dev server to production server. I need to prepare a document for the production people to get this done. Thanks in advance.

SQL Server + .Net | Transaction | Can Transaction level be esclated

Hi We are facing a unique problem which ends up causing deadlocks. We have found that We have a very heavy load OLTP Sql server 2008. In .net code we set the Transaction isolation level to Read commited while executing a SP. We find deadlocks and in the dead lock details it is explictly called out that the SP in question was executing in transaction level serializable. Lets call this SP1 The only other thing we can say is that there are some other unrelated stored procedures which access the same tables as SP1 and are executing in isolation level serializable. Is it possible for one SP to escalate isolation level like locks are escalated? We found the following links which hint this, by saying that isolation level is just a hint. http://msdn.microsoft.com/en-us/library/ms229978(v=VS.90).aspx http://technet.microsoft.com/en-us/magazine/2008.04.blocking.aspx?pr=blog http://msdn.microsoft.com/en-us/library/ms189857.aspx http://aartemiou.blogspot.com/2009/01/table-level-locking-hints-in-sql-server.html Any help in this regard will be great.

What is the best and easiest way to add SSL on a production 2007 SharePoint server

I already have a 2007 SharePoint Server up and running http://www.abcde.com/sharepointsite1 1) What is the best and easiest way to have https://www.abcde.com/sharepointsite2 in addition to have http://www.abcde.com/sharepointsite1 running as is? 2) Should I setup another web application all together with another IP address with port 443? Would that be the easiest? I can have something like this https://www.abcdefg.com/secure1 3) Please advise and comment. 4) If I don't create another web application, what are my alternatives? Thanks for the help

Moving a feature from dev server to production server

Hi, I have created a feature in my sharepoint development server. The development server is one location and the production server is in another location. After testing the feature in the dev server, I am not sure how to move the feature to the production server. I want to move only that feature, that is newly created and not the whole site. How to move a feature from dev server to the production server. Please explain the steps in detail, if possible. Thank you

error in emailing moudule frm production server

in my asp.net application i have a emailing module& i have 2 web server 1) is the development server  2) production serverdevelopment server  has all the source files & the code where i can debug  2) production server has the published files the problem that i am getting is when i am sending the email thr; development server it works fine without any error but when do the same process thr' production server i get error , the code files , teh database etc all is same - i am not able to trace the error as i am not able to debug on th eproduction system , and the mail is not senthow & where do i check out & solve the issue 

Making a copy of WSS3.00 from Production server to Development.

Dear All, I have a WSS3.0 production server which use MSSQL2008 database on Same box.Now I am planning to install a new server for developement purpose with same settings as production.Is it possibile to make a copy of production WSS on new Development server? It would be a great help if somebody can explain me the steps how to configure a copy of datas from Productin to Development incase if this option works!   Thanks to all in advance Regards Jo

web service is not working on production server

hi i am calling the webservice from acrobat javascript. it works very well in development server. but when i put the same code in production server, it doesnt call the webservice. And doesn't throw any error. Help me .

How to deploy and configure ssis packages using sql server table in testing server and production en

Hi We have three environments (development, testing and production ) I have to configure and deploy the ssis packages using sqlserver table in different environments(development, testing and production).   Three environments database structures  are same But database names are different like (DEVSERVER,SITSERVER,UATSERVER) We have 14 packages and one master package. In master package we called all 14 packages question1 First time i will deploy all (master and 14 packages). If i modify one package we need to deploy all the packages or single package deployment is enough    Please help me thanks in advance          

Very high transaction log file growth in SQL server

Hi,   I am using with below version of SQL server. Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)   Feb  9 2007 22:47:07   Copyright (c) 1988-2005 Microsoft Corporation  Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2).   One of my database transaction log file is getting full very frequently on PROD database,which i have truncated ones and shrunk ones after that i have taken full backup immediately.Again the Db tran log file grown to very big size. We are taking the transaction log backup for evry one hour. and The column shows log_reuse_wait=2 & log_reuse_wait_desc=LOG_BACKUP from sys.databases. Can you please suggest me free the transaction log space without truncating the log file.   Thanks, Gangadhar  

Serve to server Transaction Replication error


I have windows 2003 sp2 servers each hosts SQL Server 2008 SP1 standard edition. I am trying to replicate both servers, using the tutorial available in the online documentation <Tutorial: Replicating Data Between Continuously Connected Servers> which can be found at: ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10rp_1devconc/html/9c55aa3c-4664-41fc-943f-e817c31aad5e.htm

I have created the users (repl_logreader, repl_distibution, repl_snapshot, and repl_merge and setting their security. Then I have created the distibutor, setting database security as mentioned in the document, and last creating the publication with a snapshot to be run immediately, distributor and publisher are on the same server and the publication will be pushed to the subscriber. Once the publication is created succesfully, I am checking the agents to see the errors. I am always stuck with the following two error messages:

1- snapshot agent error:

Error messages:

Message: Failed to create AppDomain "mssqlsystemresource.dbo[runtime].1090".
The domain manager specified by the host could not be instantiated.
Failed to create AppDomain "mssqlsystemresource.dbo[runtime].1091".
The domain manager sp

Deploying wsp files in production server



I am using wspbulder. I created EventHandler project and builded the wsp file. I had got a wsp file, after building the application.

How to deploy this is in production server( which is a different machine).

Could someone please provide links on working with wsp for feature and Event handling and deploying the same in production server.

Thank you

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