SAinCA (11/10/2011)

---

I'll be sure to make mine around 250GB to 500GB for the tables and partitions I have to deal with.

Cheers. Appreciate the detail you went to in the...

k-335975 (11/10/2011)

---

Perry,

I usually monitor Avg. Disk sec/Read and Avg. Disk sec/Write to check disk activity, without mount points adding this counters in perfmon is not an issue. But with mount...

SAinCA (11/10/2011)

---

The dialog boxes showed a max disk size of a smidge over 7GB. Where does that come from? Is it a limitation? What...? (As in,...

rmechaber (11/10/2011)

---

For containing SQL system files, they seem like just another way to create a virtual disk/shortcut to space on an NTFS volume.[/Quote]

They may be used for system files, database...

philip.nash (11/8/2011)

---

Hi Perry,

Thanks, for the information. I deleted and then recreated end points, login etc used the new login and associated it with new endpoints and it all worked successfully.

Once...

The process differs a little, but yes it is completely possible. I run mine on ESX 😉

mfreeman 45141 (11/7/2011)

---

I have a related question. When I delete a full backup, I would like to delete all the files that are rendered useless once that full backup has...

Jonathan's C# script here

You can do this via SSIS or Jonathan Kehayias showed how to this directly through SMO. I'll see if i can find the link

they more than likely deleted a system database by mistake, as Gail says error messages please!

Windows 2003 or Windows 2008 cluster?

In a maintenance plan not sure don't use them myself. Via T-SQL, use the mirror capability in the backup database command like so

BACKUP DATABASE AdventureWorks

TO DISK = 's:\mybackups\somedatabase.bak'

MIRROR TO DISK...

Check the Windows services for a SQL Server Reporting Services service

This

declare @date datetime

set @date = '2011-11-08 21:30:00.000'

select CONVERT(VARCHAR(30), @date, 109)

Or this

declare @date datetime

set @date = '2011-11-08 21:30:00.000'

select CONVERT(VARCHAR(30), @date, 100)

alark (11/4/2011)

---

We need to set up a log shipping for SQL-2005 SP3 instance in clustered environment to DR server. The cluster and DR are in absolutely different domains that don’t...