In the organizations I have worked for - we utilize Ghost or something similar to build workstations. I tell developers that if they do anything that causes a lot...

If you have a published naming standard for your organization then you can enforce that policy. If you don't have one - and this is an issue - you...

I would recommend moving the application off that server onto it's own VM. This way you can dedicate the resources on each VM appropriately and they won't conflict.

Since this...

opc.three (3/23/2012)

---

Your readings are completely normal. SQL Server will claim as much memory as you allow it provided it thinks its needs it to efficiently serve data to clients. 1.6GB...

You can get this information from the backupset and backupmediafamily tables in msdb. You will also need to rename the files using WITH MOVE if you are restoring to...

did you cycle sql server?

Did you use the local parameter in the add?

Didn't fail for me on the 5 servers I just did this week.

steve smith-401573 (3/16/2012)

---

@ Jason A:

1. There is no AD. Two separate 'work groups'

2. The host files have been edited.

3. Ping resolves the name to the correct...

This 'issue' has been around since 2005. That option is really just a real-time cleanup option as mentioned.

I haven't worried about setting that on my systems, because I use...

This is an IO error and will cause integrity errors in your databases. You need to get your SAN team involved to check out the IO subsystem and correct...

I had an issue on one of my servers where this happened - and the solution was to log into the server and kill the databasemail executable. For some...

You need to run the command with the option to reconfigure - or the changes will not be effective until you restart SQL Server.

Execute sp_configure 'Allow Updates', 0; reconfigure with...

That issue is actually very simple to fix - somebody has run the following:

sp_configure 'Allow Updates', 1;

This caused the integrity checks to fail. Execute this:

sp_configure 'Allow Updates', 0;

And it...

Perry Whittle (3/2/2012)

---

being an administrator on the server does not necessarily give you full access, if the folder\file ACLs...

If I understood your requirements correctly - you want to be able to populate data in the 2005 instance once a day from the 2008 instance.

If that is correct, you...

If this is not a one-time process, I would recommend talking to your SAN team and seeing what options are available there.

Almost all SAN's now have snapshot/snapclone capabilities - as...