The process you are going to need to following to shrink the log file is:

1) Change recovery model to simple

ALTER...

Mike,

Since you are already looking at Red-Gate SQLBackup, try creating a new backup using SQLBackup and compression to create a smaller file. Try restoring that file - copying that...

MALIK (3/3/2008)

---

HI

i just receive an email error msg from sql server by saying this..

The SQL Server performance counter 'Percent Log Used' (instance 'DATABASE') of object 'SQLServer:Databases' is now above the...

If you are on SQL Server 2005 - you can do everything you need to do in a maintenance plan. SSMS maintenance plans include a task called Execute SQL...

One more thing you might want to consider. Before running your backup set the database into single user mode then run the backup. This will insure that there...

My guess is that you are on a cluster. The drives have been added to the cluster, but not so that SQL Server can see them. On a...

Jason Selburg (2/23/2008)

---

Hi all, this may be a simple fix, but I can't find any documentation on it, and noe of the Management Studio options seem to affect it. It...

I think what you are going to need to do is have a separate column for each OR condition, for example:

SELECT

...

,case when...

Since you have to resort to dynamic SQL anyways, don't bother with two statements and a temp table. You can do something like:

Declare @sql varchar(max);

Set

Whether or not you use simple or full recovery model is not dependent upon any features of SQL Server....

Yes - it will generate all scripts. I do not know whether or not it can be automated - but it is easy enough to find out. Download...

Muralidharan Venkatraman (2/19/2008)

---

Hi,

My transaction log file has grown to 25GB.

I did dbcc shrinkfile which did not help much.

Pls confirm if this is the right procedure.

1. Backup the database.

2. Backup...

What you are asking about is a multi-node cluster (one cluster with three nodes). You cannot (afaik) have two separate clusters sharing a node.

With that said - yes, you...

Jason Wisdom (2/14/2008)

---

Actually, that is exactly it.

I want to duplicate the database.. EXCEPT for...

Lookup_BI (2/12/2008)

---

Peso,

Im the one who logged that topic on SQLTeam as well.I currently have got the INSERT part working with some help.Currently working on Update.

I know it is a very...