Jonathan Kehayias (9/24/2010)

---

For moving files...

Hi Jonathan,

Another benefit of the backup/restore method over attach/detach or offline/online could be that the backup does not flush the plan cache for the database considered.

And I believe there's...

Hi Larry,

Thanks for your comments,

As blessonblessons says, you'll have to use the fully qualified name to be able to call the function from any other database.

It had been a...

Hi Siraj,

Yes you can call:

[font="Courier New"][System.IO.DriveInfo]::GetDrives() | Format-Table [/font]

...from the powershell prompt.

SQueaLer1 (9/21/2010)

---

Hi David,

I appreciate the concept but I have to disagree with the approach. We programmers can come up with a lot of "nice" solutions, but they don't always work...

Hi Harold / Jayant,

Very good question. What is clear is that DriveInfo does not consider mount points, so they won't be reported by the sqlclr function. There are ways...

Matt Whitfield (9/21/2010)

---

David

Yes, the DriveInfo class does require UNSAFE because of the permissions, I said that - my bad.

However, I can't agree with the rest of what you've said. I...

Hi Matt,

I agree using a static field will force the assembly to be considered as UNSAFE, but diving into the IO system would lead to the same path anyway.

I...

Sorry Kevin,

Here you go: https://sourceforge.net/projects/fnfixeddrives/[/url]

Hi Arjan,

It is a tough one, because the error may be pointing at the way DPM replicates the data and tlog files. A PageAudit error means something in the header...

Maybe you...

Hi charles,

Just a though, but haven't you tried to switch to BULK_LOGGED before you run the index rebuild ? As you don't mention it, I'm wondering if there are any...

Hi

Can you provide the output of:

^{select name from Name1.sys.database_files}

GO

restore filelistonly from disk='<your path to your full backup>'

GO

thx,

Hi,

There are tricks to setup SSIS as a clustered resource but it is not designed to be cluster-aware as SQL Server Database Engine or SSAS. But you can perfectly setup...

Hi,

You need to consider whether you have a large backlog or not at the principal, if there are transactions on the fly, etc... because the failover will be delayed until...