Have you /3GB, /USERVA, /PAE or AWE on on your active or passive server?

-LK

Hello Singh,

"set the Page File of a system to 1.5 times of the physical available memory"...

Can you tell how to change this?

-LK

We can't use Express edition as an alerting server in logshipping. Can we use alerting server as a primary or standby server for logshipping?

oK

SELECT SU.name AS username, SL.dbname, SL.name AS loginname

FROM sys.syslogins SL

RIGHT OUTER JOIN sysusers SU

ON SL.sid = SU.sid

Add some other columns from syslogins table as per your requirement

-LK

There are four ways of memory extension ie /3GB, /USERVA, /PAE and AWE. Are all the windows technologies or any one of them is sql server technology?

Post only if you...

I think you are quite correct.

How msdb is affected when DTA is run, David?

-LK

Whenever any backup is taken then msdb..backupset table is updated. Just see whether the data files for msdb is set for autogrowth. Verify the %Free space for the disk drive...

Crashes?? Do you mean sql service stops when you execute statement to create new view or only ssms goes down?

I have only production servers with me so can't do that....

I read somewhere that you can bcp all logins to hard drive and then import them back using bcp on other server. Unfortunately I don't have readymade code for you....

Gianlucca,

Are you really sure and do you have practical experience of this as well? The reason I am asking is how the database log would contain the data which is...

Hello Jeff/Victor and Rateesh,

I am confused with following statement.

"For log backup that contains bulk operations, the database can be recovered just to end of the log backup and the point...

According to me this is not possible. When you add any new step in the job then it asks for SSIS package and its location. There is no option of...

can't understand your question. Give some more info..

-LK

Is it the same you are saying "If we set up the secondary server as standby then we have to close the connections everytime the restore job runs".

-LK

sp_who2 is ur friend. You can use following from performance monitor:

SQLServer:Locks Lock Timeouts/sec _Total

SQLServer:Locks Number of Deadlocks/sec _Total

-LK