Hi,

you need Enterprise Editions only if you want to use the out-of-the-box logshipping procedures, if money is scarce you can allways implement logshipping by yourself. In that case Standard Edition...

try adding the path to xcopy, and no /Q option

c:\winnt\system32\xcopy.exe "c:\Inetpub\ftproot\adam\MisBack\Bais\%1.AIS" "c:\Inetpub\ftproot\adam\Mission"

the script should work for all databases, and you can substitute model with tempdb.

if you use sp_change_users_login with AUTO_FIX you have to overwrite your existing logins passwords, which may or...

hi, i'm using this after restores:

------------------------------------------------------------

declare @login sysname

declare log_curs cursor for

select name from sysusers where upper(name) 'DBO' and status=2

open log_curs

fetch next from log_curs into @login

WHILE...

try:

SET @cmd = 'c:\ReloadMission\Rmission.bat ' + @mid + ' >> c:\miss.log'

or

SET @cmd = 'c:\ReloadMission\Rmission.bat ' + @mid + ' >> c:\miss.log 2>&1'

and look at c:\miss.log on the server...

karl

regarding the problem with your script:

you need to put all sql-commands into 1 string and execute that, since the "use @dbname" is only valid for the scope of the exec...

karl

Hi Scott,

seems to me you are using local accounts on each server. Do you have a nt- or ads-domain? if so, you might use a domain account, which would exist...

Hi,

you might put the create-login-scripts into a temp table and bcp that out to a text file...

regards karl

Hmm, perhaps a dumb question, but why don't you put master and msdb on the storage array too? putting them on a different storage system just adds another point of...

Can you post the error message for sp_repldone?

karl

Did you try:

"Apex SQL Log

Apex SQL Log is a powerful Microsoft SQL Server log auditing tool that analyzes SQL Server's own transaction log to display information on data and structure...

or similar to sushila's:

Alan Hadsell

If brute force doesn't work, you aren't using enough.

Hi,

you should be aware that each disk can only be contained in 1 cluster group, which can be owned only by 1 Node. Therefore each disk can be accessed only...

Is the backup disk in the same cluster group as the sql server?

do you access the disk via drive letter or via network share?

sql server native backup or third party...

Hi,

a good starting point is

How to Perform SQL Server Log Shipping

karl