.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

Move transaction logs with Power Shell?

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :

I'm new to Power Shell, but would like to see how powerful it is.  I need to move some transaction logs from one volume to another with more space.  Is it possible with Power Shell?


View Complete Post

More Related Resource Links

SQL 2005 LSBackup_SID transaction logs hung...

Hello folks, I've searched google dry.. I feel as if I am the only one with this issue (hope not)!!.. for some reason my transaction logs stopped generating files via the job LSBackup_sid, i had my log shipping very nicely setup my secondary DB was in (restoring mode) LScopy and LS restore were running quite nicely but not the LSbackup_sid job on the primary simply stopped creating transaction logs to any shared folder I point it to. I have tried to redo all the shipping log process, I have tried pointing it to a different path, i even restored my secondary DR database and brought it up with SAP to see if I can get my trn files back on the primary.. there simply is no error on the LSBackup job it just says running forever: see below   Date,Source,Severity,Step ID,Server,Job Name,Step Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted 09/07/2010 00:22:01,LSBackup_PAB,Unknown,,,LSBackup_PAB,,,In progress,00:00:18.4770000,,,,,, 09/07/2010 00:21:43,LSBackup_PAB,Unknown,1,DBGRPNEW,LSBackup_PAB,Log shipping backup log job step.,,2010-09-07 00:21:48.30 Backing up transaction log. Primary Database: 'PAB'<c/> Log Backup File: '\\sapprd2\bckp_drc\PAB_20100906212148.trn',00:00:05,0,0,,,,0 09/07/2010 00:21:43,LSBackup_PAB,Unknown,1,DBGRPNEW,LSBackup_PAB,Log shipping backup log job step.,

Transaction logs will not shrink


We have two databases on our SQL Server 2000 installation that has huge transaction logs. One of them is at 32 GB and the other is around 48 GB. When I go into the Enterprise Manager and select shrink, and then select file and the log file, it shows the actual size is much less like around 2-3 GB. After selecting to shrink the file to this size (2-3GB) and waiting, when finished, I see no change in file size. I've gone back into shrink and the file size still remains the same, like it is not shrinking it properly. We also used Backup Exec and backed up the logs with trunicate. What can we do to shrink these log files?

Deattach SQL Server database using Power Shell


Hello team,

I am newbie to powershell .Can any one please help me out how  to dettach a SQL server database  using power shell command.I have tried the below command but it throws me an exception

Method invocation failed because [Microsoft.SqlServer.Management.Smo.Database] doesn't contain a method named 'detach'.

 [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SMO") >$NULL
$server = new-object ('Microsoft.SqlServer.Management.Smo.Server') 'MS-BIZ-C20149'
$database|select-object name

 Thanks in advance

Delete Transaction Logs


HELP!  I have a question which I think should be pretty simple and I can't seem to find a simple answer...

I am developing an app that uses SQL Server as the back end.  It appears I was not managing the DB well because the transaction log has grown so large it has consumed my whole hard disk. The log as of now is about 50GB for an app where the database is less than 0.3GB.  The app is under development and the logs are of no value to me right now.  I just want to DELETE them and start them over at 0GB.  Is this possible?  I have read all kinds of posts about backing up the logs in order to shrink them.  I can't back them up, I tried... I am out of space.  I just want to delete them.  I think I see where I can do this under DB Management.  What happens if I create a new log file and then delete the old one.  I don't care about recover as the DB is constantly being deleted from and all tables being recreated.


- Charles


Transaction Logs growing tremendously


We have an ASP.Net2.0 application with SQL server 2005 as Database. We use a database ASPState in SQL server to store ASP.Net Session State. Recently, the transaction log of this database started increasing by 4Gb for every 15 minutes that it reached 20+GB and it got the server down.

We investigated from Application side and the transaction in the tables which didn't end up in the root cause.

Is there any smarter way of analysing this issue to find the Root Cause?

Any suggestions for avoiding such crash in feature would be gratefully accepted.

Other Details: It's a SQL Server 2005 Enterprise x64 edition deployed on a windows server 2003 box.



Transaction logs dont get truncated after backup


Hi all,

I've used TFS Power Tools to setup a db backup plan for a TFS 2010 instance using SQL Server 2008. The result is a sheduled full backup at 02:00 each night and a transaction log backup every 2 hours. The backups work but there is a problem with the transaction logs not being truncated after backup. When this was brought to my attention typically all the transaction logs were 10-30 times larger than the data files... I searched the www and found these two useful commands:

SELECT name, recovery_model_desc, log_reuse_wait, log_reuse_wait_desc FROM sys.databases
dbcc sqlperf(logspace);

For all relevant databases log_reuse_wait = 2 and log_reuse_wait_desc = LOG_BACKUP. The dbcc command told me that log files were about 95% in use.

Searched som more on thee www and ended up with this manual procedure to "fix" the problem:

  1. Right click db and select Tasks -> Backup...
  2. Change Backyp type to Trasanction Log and press Ok.
  3. Repeat steps 1 & 2. (Had to do it twice and

Power of using Clause in SharePoint

The Using Clause will help to avoid memory leaks in SharePoint by automatically Disposing the MOSS objects.

For example when we create SPSite and SPWeb objects, if we don't dispose it explicitly it might create memory leaks,

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:

Multiple web methods in one transaction


Hi everyone

Sorry I am kinda new in web services, so it may sound a bit newbish question.

We have a web service that comunicates with the database and exposes web methods that enables the application to access the database. Each method does only one operation (Insert, Update or Delete). What I need to do is create a transaction that will be consisted of multiple calls to the database, meaning multiple calls of more then one web methods. Can I do that? (I read that if the web method does not throw exception - or ContextUtil.SetAbort() is not called - the transaction will be commited automatically when the web method finishes executing, which I don't want to happen because I want to call another web method in the same transaction, and then manually commit the transaction)

Thank you in advance.



i have got a project to be done on the solaris to be done on JSP but i m so much impressed with the power of .net that i want to do in asp.net so is it posssible to work with ASP.NET on solaris

Cloud Computing: Patterns For High Availability, Scalability, And Computing Power With Windows Azure


Here we examine the typical cloud platform architecture and some common architectural patterns, along with their implementation on the Windows Azure offering from Microsoft.

Joshy Joseph

MSDN Magazine May 2009

Usability in Practice: The Power of Personas


A persona is a description of a fictional person representing an amalgamation of traits found in a segment of your users. Emplolying personas arms you with a powerful foundation on which to base design decisions.

Dr. Charles B. Kreitzberg and Ambrose Little

MSDN Magazine April 2009

Editor's Note: A Look Back As We Move Forward


Here's a look at a year's worth of coverage and changes at MSDN Magazine in response to reader requests.

Howard Dierking

MSDN Magazine January 2009

Team System: Essential Power Tools.


Brian Randell introduces you to some crucial Power Tools for getting the most out of Team System.

Brian Randell

MSDN Magazine August 2008

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

Mobility: Make Your WPF Apps Power-Aware


Here Andre Michaud shows you how to use power notifications to make your applications power aware.

Andre Michaud

MSDN Magazine July 2007

VISUAL BASIC: Unleash The Power Of Query In Visual Studio "Orcas"


LINQ, coming in the next version Visual Studio, codename "Orcas", adds type-safe data querying to .NET languages.

Ting Liang and Kit George

MSDN Magazine June 2007

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