Each instance needs it's own Network Name, IP and Disks - don't they?

Here are a few more resources for you

SQL Performance Dashboard.

http://www.microsoft.com/downloads/details.aspx?FamilyId=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en#Instructions

Install and then run the setup.sql script on your instance. Be sure to look at the instructions on...

There are new roles in the MSDB. Microsoft site has some detailed info. Google is your friend.:D

Either use a backup file or detach, copy, reattach - then fix your users.

Backup file will take more time since it needs to be created and then copied.

Moving...

Patricia Johnson (8/26/2008)

---

No they are not all developers. I have queried the application team to determine if all the 50+ users need to been defined and will go from...

>>My concern is that a user could inadvertently access the production database when they meant to access the test database. Since I don't have any other choice right now,...

Was SQL on during the defrag? It needs to be turned off I believe, otherwise the files are locked.

No gimmicks, just sql dependency tracker from redgate for us. You could use some of this info to bang something up:

http://msdn.microsoft.com/en-us/library/ms345449.aspx

Theres an example to show what x...

http://www.google.com/search?q=troubleshooting+sql+memory+problems&sourceid=ie7&rls=com.microsoft:en-US&ie=utf8&oe=utf8

The first link has a few counters you could look at.

jlp3630 (8/26/2008)

---

Sam,

Here are the responses to your questions:

1Q. What are your memory settings in sql server?

1A. What sql server memory settings are you referring to? And how do you access...

Maybe you can use this to see what has the file locked:

http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx

What are your memory settings in sql server?

Have you tried walking to the machine and logging on, instead of rdp?

What types of disks are you using?

Good article,

I'm assuming the same method will work with encrypting backups. Is this true?

Can a domain admin come in an decrypt this data? I'd like this not to...

New_to_being_DBA (7/31/2008)

---

This is one proposed plan: D: drive RAID 5 (780GB), for databases for all sites; on the other controller, E:drive RAID 1 (146) for transaction log, F:drive RAID 1...

Make sure you keep an eye on your transaction log sizes.

Getting Oracle drivers working on our server was a pain, give yourself some time if you need that.