OK- the easy answer is "yes, probably safe to shrink that file"... BUT, I want you to really understand what you are doing.

There is some reason that the...

SIMPLE is the "Recovery Model" of the database. A database can operate in a few different mode- or recovery models. The three possiblities are SIMPLE, FULL and BULK...

imSQrLy (11/4/2011)

---

NJ-DBA (11/4/2011)

---

HI Jimmy,

If I correctly understand your problem, I'm pretty sure this is exactly the purpose of SQL Agent Proxies: http://msdn.microsoft.com/en-us/library/ms189064.aspx%5B/quote%5D

I know about proxies. But they...

HI Jimmy,

If I correctly understand your problem, I'm pretty sure this is exactly the purpose of SQL Agent Proxies: http://msdn.microsoft.com/en-us/library/ms189064.aspx

pat-261672 (11/4/2011)

---

Hi,

The DB mail is set to use the basic with my username and password.

Also, I have full rights to send mail on my regular computer and i can...

NJ-DBA (11/4/2011)

---

pat-261672 (11/4/2011)

---

Hi,

i have setup the database mail fine and can send database mail. But from SSRS subcription on SQL 2008 sp1. but it sends out failing messge:

Failure sending mail:...

pat-261672 (11/4/2011)

---

Hi,

i have setup the database mail fine and can send database mail. But from SSRS subcription on SQL 2008 sp1. but it sends out failing messge:

Failure sending mail: The...

If you have a log backup job or an incremental backup job which explicitly mentions a database which does not exist, then that's a problem. Disabling the job is...

So you have some job out there looking for a db that doesnt exist. Should be pretty easy to compare the login failure times to job history and track...

depending on the requirments, you could even look at a list of sources and destinations and wrap the whole thing in a for loop container.

Not a SSIS developer, but I can give you some insight from the database adminstrative side.

I know that my environment, developer use "Set Values" inside of the SQL...

Jeffrey Williams 3188 (11/3/2011)

---

For most systems, I will setup a single domain account per SQL Server instance and run all services under that account.

Only on systems where there is a...

also here http://technet.microsoft.com/en-us/library/cc966545.aspx

The LocalSystem account is the most highly privledge account on the server. It has permissions even beyond what is assiged to the local administrators group.

I like the...

jared-709193 (11/3/2011)

---

Can anyone provide a list of ALL of the domain accounts they would have set up to do a "proper" or "best practices" install of all SQL Server services?...