Steve Maxwell (7/21/2008)

---

Depends on a couple of factors:

- Are your disks on a SAN?

- How big are your DB's likely to be?

- How active are your DB's ?

- Whay type...

Hi,

if i use in the @path 'C:\Backup' where my BAK files are,the script looks for the BAK file in C:\BackupFileName.BAK why?

i think that i can manager with the code.

but how can i catch the hostname when a user is login to the SQL with the DDL Trigger logon event?

if i...

i don't understand what you are saying.

2xeon 3.0GHZ with HT enabled

what about /3GB and /PAE do i need to set them UP?

my Server is W2K3 ENT 64BIT and SQL Dev 64BIT.

I've reduce the max memory to 4096.

i don't have other processes running beside SQL Server(TLog and Full Backup by Maintenance Plan).

no SSIS,DTS,Application Code,this is very standard SQL Server.

I'm responsible for...

Jeffrey Williams (6/15/2008)

---

With the system using 5.7GB of memory (page file) - you are definitely running into memory issues. This is only leaving approximately 300MB available to the OS...

the PF show 5.7GB usage.

first - i didn't understand your first question.

second - min = 1500 , max = 5200

yes i've configured the lock pages in memory for the SQL server service that start...

this i know.

I'm talking about the ability to raise an error message that is in the sys.messages.

you say that i can't raise any error that is shipped with the product(for...

i didn't find any easy answer for that.

i try to look in BOL for RAISERROR 9100,and i can't make it.

can you help me Plz with the syntax to raise the ERROR 9100.

THX

yes it's better.but for my second question - if i setup alert to listen for severity 23 and message id 9100 is in the "logged message" in the sys.messages,if error...

i didn't understand anything from your answer.