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
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?
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'.
$server = new-object ('Microsoft.SqlServer.Management.Smo.Server') 'MS-BIZ-C20149'
Thanks in advance
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.
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.
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
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:
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.
Here we examine the typical cloud platform architecture and some common architectural patterns, along with their implementation on the Windows Azure offering from Microsoft.
MSDN Magazine May 2009
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
Here's a look at a year's worth of coverage and changes at MSDN Magazine in response to reader requests.
MSDN Magazine January 2009
Brian Randell introduces you to some crucial Power Tools for getting the most out of Team System.
MSDN Magazine August 2008
This month the Toolbox column takes a look at database logging, Joel Spolsky's blog, printing code projects, and ASP.NET reading.
MSDN Magazine May 2008
Here Andre Michaud shows you how to use power notifications to make your applications power aware.
MSDN Magazine July 2007
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