the create user for login doesn't work if username and loginname are not the same.

you have to add the loginname too.

i add on every place where the dbusrname is, also...

if it is no security problem for you, you can allow everyone to share permissions AND NTFS Security on the server you want to backup thru.

if you cant do that,...

yes, unfortunately there is a need for vbs because i have about 13000 lines of code in a HTA (vbs/wmi) and i dont want to recode this in another language,...

one year has gone but the problem is the same.

so i like to ask again, if anyone has a working VBS with the DMO command "ExecuteWithResultAndMessage" where the results and...

no sqlserver can not backup databases which are in recoverymode (the mirror role).

but my idea behind the question is, the possibility to backup all databases on both servers (principal and...

yes, it has many lines to read but only a view lines about mirroring.

so i can tell you that it doesnt help to have this guide.

bye

Michael

i hope you had done the steps below exactly as i descripe.

--create Partner Information on Mirror (first !)

ALTER DATABASE SET PARTNER = 'TCP://servername.full.qualified.domain:5022'

--create Partner Information on Principal...

shrinking is not a real choice because the DB will be at 100GB within a year

i think we have to buy another 150GB for things like this or if our...

for wmi events there exist the WbemScripting.SWbemSink event sink which works fine but i have no idea how to implement a event sink for the sqldmo Backup event.

*M*

we make all backups with netbackup

full, diff and t-log and all works fine also the restores

but we have virtual tapes (disks) to buffer the streams and if there is time...

i like the sp_help_revlogin

with this SP you can generate a script with all userlogins,sid,password ...

than you only need to bring the needed scriptlines to the new server and run...

the 'nn rows affected' message was only a little sample for what i mean.

the really important messages like error messages and so on are the real background on this question.

greetz

Michael

found rsscripter which generate a script with the right syntax

cu

Michael

hi there,

i'm not familiar with this kind of coding but in WMI you set the from file in a object variable (like oFrom)

and say oFrom.move ("c:\somewhere\file.ext")

so i think the information...