Hi,

that behavior might occur if your msdb is full, so the actual restore is successfull, but the history of it can not be written to msdb.

are there any...

Hi,

if you look in EM at Management-Current Activity the 4th column from the right side shows the used network library.

On the client pc use start - run - cliconfg to...

Hi,

seems to me you applied a service pack or hotfix only to the active node, and forgot to do it on the passive node also.

regards,

karl

There is

select top 10 * from ::fn_dblog( default, default )

but it does not give the actual sql statements.

karl

Hi,

if you want to use Outlook, be sure to have only the Exchange-Mailbox in your Mail-Profile, not any Mailbox-File.

An other possibility is using a command line tool like commail.

(For sending...

Hi,

try starting SQL-Server with trace flag 3608, go to table sysaltfiles and look, if there are entries for tempdb.

If no, create them, if yes, control the path...

Hope this helps

karl

Hi,

you should set up the target server as linked server, and then execute

<linked server>.msdb.dbo.sp_start_job @Job_name=<jab name>

regards

karl

Hi,

a quick hack is:

declare @pwd sysname;

declare @pwd1 sysname;

select @pwd1=str(rand(datename(ms,getdate()))*1000000000);

select @pwd=substring(@pwd1,4,len(@pwd1));

It generates quasi random strings containing 7 numbers.

Karl

Hi,

as soon as you get the database to online, you couls use the undocumented procedures

sp_delete_backuphistory

or

sp_delete_backup_and_restore_history

to truncate your backup history...

regards

karl

Yes, it is possible to do log shipping from a sql-cluster.

Actually log shipping in no other beast as doing regular backups and restores...

If you've got sql server enterprise edition you can...

Hi,

does the content of sysfiles and sysfiles1 reflect the new location?

how about master.dbo.sysaltfiles, does the content correlate?

regards karl

perhaps something like that?

set @max-2 = 0

set @sql = 'SELECT @max-2 = max(ordinal_position) FROM tempdb.information_schema.columns WITH (NOLOCK) where table_name = '''+@temp_table + '2'''

EXEC...

If you create a job on secondaryserver for the copy-command and log the output to file (second register of job-step) you might get an error-msg for debugging...

karl

could you post the copy command here?

Hi,

if you copy manually, you use the security-context of your login user.

Does copying work if you log into secondary server with the service-account?

Also the copy-job might fail because at the...