IT researcher (4/29/2013)

---

The only reason to rename the file is for automated backup. I do have my own backup application where I can automate backup on daily,weekly or monthly...

Steve JP (4/27/2013)

---

Depends as the log file doesn't always want to shrink. If it doesn't then like I said a single file attach is a sledgehammer approach, never said it...

Let's not forget that installing SSIS on its own server requires purchasing separate licenses for SQL Server on that server. If you are running SSIS on an ETL server...

The drives will not be available to SQL Server until you make the SQL Server resource dependent on those new drives. They can still be accessed using UNC path...

No need for a custom install...

That is a standard report provided within SSMS...right-click your database, select Reports, Standard Reports and the Disk Usage by Top Tables report.

Worse...what happens...

If you have ever created a .bat file to run BCP commands - then Powershell is probably something to look into. It is a command line utility that gives...

But...what if truncate doesn't actually remove everything that was there before? Don't we have to be sure we delete it before we insert? :w00t:

John Mitchell-245523 (4/17/2013)

---

It's OK to shrink files if the reason they've grown isn't likely to be repeated. This is indeed the case in your situation - somebody set the...

When you setup a linked server - you also have to define the security context for each connection using the linked server. It sounds to me like you have...

Michael Valentine Jones (4/2/2013)

---

Why would the service account get locked out? Are you using the same service account on more than one server?

To answer your question, we setup new...

From the 2008 R2 Requirements:

Note

Installing .NET Framework 2.0 SP2: .NET Framework 2.0 SP2 is not available as a separate download. You will need to install .NET Framework 3.5 SP1 which...

amy26 (4/2/2013)

---

GilaMonster (4/2/2013)

---

Why not?

Comparability level doesn't disable new features, it just...

Going back to the original point...I don't think optimizing the view is going to help a whole lot here.

The OP is querying this view using a like statement that forces...

I am not going to review what you are doing wrong - because the whole idea is wrong.

You do not want to setup a process to shrink log files on...