Grant Fritchey (3/20/2008)

---

Sorry, left out a bit of detail.

Instead of looking at the System Monitor, go to the Performance Logs and Alerts and set up a new Counter Logs using...

I downloaded and installed the performance collector as well, yet I still don't have the service in my services list?

Regardless, not sure If this is what I'm looking for ......

Well, I'm happy to report that while mirroring is suspended, a TLOG backup does NOT remove committed data that has not yet been applied to the mirror. I was able...

Two problems here ...

1) You don't need sysadmin to modify jobs, there are new roles with in the MSDB database you can apply to users. Check out BOL for the...

sys.sysfiles is reporting:

- data - 750904kb

- log - 30152kb

file size on disk is reporting:

- data - 6gb

- log - 241mb

The above two match up and should be correct, but the...

Think I found my answer ...

http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx

Database mirroring will not be able to initialize if transaction log records have been truncated from the log by log backups. Therefore you must restore...

Look at my SSMS ... sysaltfiles vs sysfiles ...

Then compare the properties window of tempdb, vs. the size on disk.

Two different sets of sizes being reported for the size...

Same here ... I think I'm gonna let my TLOG backup run and see what happens when I resume the mirror out of sheer curiosity ...

I'd recommend reading this, gives a nice easy to follow comparison:

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1069109,00.html

Regardless, what is your goal here? Is your database highly transactional? Is performance an issue? Do you need the ability...

Duran (3/13/2008)

---

Hello,

Now I was going to create a global security group with all the accounts in and assign it full control to both the drives that will contain the DB's...

Check your application event viewer ... this is usually caused by a service running with invalid credentials, or the agent improperly configured (logs are pointing to an invalid directory for...

Like most DTS packages, you don't get the full error in the agent log ...

This SQL Mail session started is not telling us much ...

You need to pull out the...

I could get into more detail, but a busy at the moment ... quick rundown:

LiteSpeed/Redgate is better because:

- Faster

- Higher compressions

- Encryption

- Historical logging (other apps may offer, not sure...

See attached ... I made this last month, but never really got to implement it as my problem resolved itself for the most part. I tested it out back then...

GF (3/11/2008)

---

Hello,

I am trying to determine which drive SQL 2005 was installed from.

Where is this information located. I tried to search the registry but I found nothing that would tell...