Colin, thanks for your info.

I see no reason why you cannot switch from mirroring to log shipping, using the process you describe.

thanks guys, good to have that confirmed.

cheers

george

Colin, are you saying you would want to start the mirror database as the standby database iin a log shipping set up? I guess if you were 100% certain databases...

this sounds familiar but struggling to remember details (not had problem myself but have read web articles). I think it is due to the system stored proc that lists the...

or there is also dbcc inputbuffer(spid)

I presume SQL service is running under local system account? NT Authority\system is this account. various sql background services will run under this account (inc. SQLAgent)

Bill, it is perfectly ok to take full backups whenever you want of your logshipped database, all the full backup does is put an entry in the log that a...

guys, thanks for the replies. I have a good idea of the i/o patterns from the current live server and am configuring sqlio using these figures. When we have an...

ok I have sussed it out. sqlio does create the file and expand it to size specified. A problem for me as this is the first server connected to SAN...

table master..sysprocesses is the place to look to see what info you have on each connection. column net_address will give the mac address user connected from so that might be...

Hi,

expanding on the above it is the testile that I am not sure about (mostly). Do I just specify which path to put the testfile on and SQLio creates and...

also, yes you can logship to multiple standby servers

I do not think this scenario of A loghip to B, B replicate to C is going to work. You need to logship from A to B, and replicate from...

correct. though new server has the users, they are defined in the app databases, just does not have logins , which are defined in master. So you can go ahead...

sorry, as soon as you take the standby database out of standby mode, you have to reinitialise log shipping by restoring a full database backup in norecovery or standby mode,...