Hi,

try

DECLARE @dir varchar(255)

SET @dir = 'DIR /B "C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\ + @dbname + _db_ + Right(convert(char(8),getdate(),112),8) + '*' + '"'

EXEC master.dbo.xp_cmdshell @DIR

regards karl

Hi Linda,

do you use a backup software that compresses the backups on the fly? That should reduce the time for a new start at least to a half.

How often do...

Also it's possible that by adding the new clause the query optimizer is now using a different, better suited index for the subquery...

Just to ask for the obvious, inside the job, the job-steps are running as sa or with a windows account?

Did you restart the SQL Service Agent yet?

Hi,

have a look at the event logs of your servers. Are there any events about loosing the connection to the domain servers?

Are security events logged on these servers? Any errors...

Hi,

would it not be easier to simply create a directory "c:\backups", and put the backup there?

Just because "C:\Program Files\Microsoft SQL Server\MSSQL\Backups" is the default you are not required to use...

Hi,

have a look at http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx

Microsoft tells us that index reorganisation has an impact on performance only for indexes bigger than 1000 pages...

regards karl

Hi,

usage of sp_addlinkedsrvlogin:

sp_addlinkedsrvlogin [ @rmtsrvname = ] 'rmtsrvname'

[ , [ @useself = ] 'useself' ]

[ , [ @locallogin = ]...

Hi Alan,

are you running sp_updatestats and sp_createstats frequently?

According to MS even if auto_update_statistices and auto_create_statistics is ON there may be statistics not created or not updated...

regards karl

Hi,

i'm using

SELECT * FROM OPENQUERY( [SERVER1],

'SELECT sAMAccountName, userPrincipalName, company, department, Name, givenName, SN, Mail, telephoneNumber, mobile,

l, physicalDeliveryOfficeName, postalCode, streetAddress,...

Or, if you can correlate application user to ads user, you can get info via a stored procedure from ads.

(i'm assuming the user is named somehow in the application)

regards karl

Hi Krissy,

depending on the way you implement the logshipping you might want to time the restore into the db too. If copying and restoring is done from server1 you have...

@jason

Yes, that's in my opinion the main reason for having standby servers via logshipping, if the backups are restored to the standby you _know_ they are valid...

In the...

Hi,

one thing to keep in mind is the reliability. Native sql server backup has never failed for me, but in my company we've had both Arcserve and Veritas Backup Exec...