How are you connecting?

Shouldnt be an issue with clients. I use 32 and 64-bit client and 2008 32-bit without issue. Also check the browser service is running (it isnt clustered).

Hey there,

We run the same setup as you. We mirror 8 databases (MS suggested is upto 10 but not sure what stats thats based on). Our main database is bursty...

I think the reason people tend to prefer MB over % is as you said due to percentage sizes.

For example 10% of 1GB is 100MB (no problem); however 10% of...

Does sound like a buffer issue. I'm not sure if failing a mirror over, truncates the caches and query plans but if it did that would be why you...

Eduard (11/25/2009)

---

Schadenfreude-Mei (11/25/2009)

---

Why exactly are you trying to do this? It is a bit concerning that you dont have access to delete users but are talking about disabling them.

You...

If you want to clear down the CLR and QUery plan caches you can use:

dbcc freeproccache

DBCC FREESYSTEMCACHE ('ALL')

DBCC DROPCLEANBUFFERS

But you really need to find out whats using your memory. Have...

Why exactly are you trying to do this? It is a bit concerning that you dont have access to delete users but are talking about disabling them.

You also ask...

Have you done any research into this? A quick google search generally reveals all..

Some reading:

http://www.sql-server-performance.com/tips/rebuilding_indexes_p1.aspx

http://www.mssqltips.com/tip.asp?tip=1367

http://msdn.microsoft.com/en-us/library/aa258828(SQL.80).aspx

Have fun 🙂

Henrico Bekker (11/20/2009)

---

one .exe file? are you calling an application? not sure what you are up to...

but....

In BI, add a process task, and point it to your .exe

save package into...

What is the output...

USE [msdb]

GO

DECLARE @jobId BINARY(16)

EXEC msdb.dbo.sp_add_job @job_name=N'{TEST JOB}',

@enabled=1,

@notify_level_eventlog=0,

@notify_level_email=2,

@notify_level_netsend=2,

@notify_level_page=2,

@delete_level=0,

@category_name=N'[Uncategorized (Local)]',

@owner_login_name=N'DOMAIN\USER', @job_id = @jobId OUTPUT

select @jobId

GO

EXEC msdb.dbo.sp_add_jobserver @job_name=N'{TEST JOB}', @server_name = N'SQLSERVER'

GO

USE [msdb]

GO

EXEC msdb.dbo.sp_add_jobstep...

CirquedeSQLeil (11/16/2009)

---

GSquared (11/16/2009)

---

Jeffrey Williams-493691 (11/16/2009)

---

What if you...

You most likely need to 'relay' through your mail server. By default exchange does not allow this. Speak to your mail administrator.

If you right click on the service and select properties, you'll see the path to the actual .exe and based on thaat you should be able to work out (ie...

Just attach the mdf you have and then in the bottom box (that displays the two files), highlight the log and click remove.

When you click OK, the mdf/database will be...