Yep, that is it - once the drive is added as a resource for SQL Server, you can move the group to test.

I would also test by opening any dialog...

What is Yosemite Backup? Is this something provided by your SAN vendor to perform some type of Snap/Snapshot backups on the SAN?

Anyways, all of these errors are being generated...

What version of SQL Server do you have on the server?

What version do you have on your desktop?

You will get this error if you load the SSIS package onto the...

Rob Symonds (5/23/2008)

---

Next week I have to add a LUN to our Windows 2003/SQL Server 2005 production cluster and move some log files to it. I have added a LUN...

Can't really answer that - it is something that you are going to have to test yourself to see if it does in fact slow the system down.

Jeff

I am not sure if it checks the contents or uses information in the backupset table in msdb - however, it will not cleanup non SQL Server created files.

You can...

gourab_sahoo (5/23/2008)

---

Sorry guys for incomplete information. Here is the error that we are getting.

Msg 241, Level 16, State 1, Line 3

Conversion failed when converting datetime from character string.

When i do...

Okay, so lookup PIVOT and see if that will give you what you need.

Jeff

Try modifying the linked server configuration and change the following server options:

Collation Compatible

Use Remote Collation

Change the first parameter from it's current setting (defaults to False) and try your query. ...

It sounds like you want a crosstab - if so, lookup PIVOT in BOL. Generally though, this is much easier to do in whatever reporting tool you are using...

What does not working mean? Are you getting an error? No results? Invalid Results?

That is interesting - since everything I can find says that statistics on indexes will be rebuilt with a full scan.

Jeff

Are you running on AMD? If so, you can get a BIOS update from AMD to fix this issue. Work with your hardware vendor and/or AMD to get...

The standard maintenance cleanup task will not remove files that are not native backup files. Since you are using a 3rd party backup utility (SQL Litespeed?), you need to...

If I switch from sysindexes to sys.indexes, I have no access to information as to how many rows in the index have been modified since the latest update. I need...