wavesmash (6/27/2008)

---

So there is no way to automatically sync table schema or stored proc schema changes during replication without using a 3rd-party tool?

With database mirroring, is a shared drive (SAN)...

wavesmash (6/27/2008)

---

Thanks for the clarification. Alarm bells went off when I thought log shipping wasn't syncing schema changes.

Is it possible to replicate schema changes & stored procedure changes and...

for security reasons we go for every sql instance runs under a different account (unless part of logshipped\mirrored pair) with different passwords.

sa password also different on each server.

all dbas in...

wavesmash (6/27/2008)

---

Hi Paul,

Great article. If schema changes are not copied during log shipping, what is the best method to maintain updates to scripts and tables with large databases...

what id do you normally connect to MSDE with? use that id if it has sa privelages, or use the sa id itself if you know the password

osql -Sservername -Usa...

you have described a typical simple transactional replication scenario, so this sounds like your best bet.

log shipping will make the mumbai db unusable whilst the log so being loaded, so...

well that looks like it is removing files from a backup directory, but cannot say what files fromminfo supplied. I recommend getting together with admin responsible for legato andgoing thru...

once you online the database to modify it you will not be able to restore further differential backups. Hence my feeling you need to change your strategy for recovering users

copy the logins over using sp_help_revlogin, that will maintain the sids and you won't get orphaned users. As this is SQL2000 ensure you get the correct default database and language...

on seeing the date on Brads editorial, it seems the best way to save time is to do your work 3 days into the future.:D

its been touched in before, but disaster recovery has to be in there, being able to get the app up and running again no matter what is lost - from...

the syntax errors could be 'go' statements within the jobs, this throws out the syntax checking. replace any of these with ';' and it will work.

I have used Ed's code...

if a log backup is happening, or a truncate log, it will be recorded in your errorlog. go through that to see if you can find evidence of a log...

And time to market should never be a problem... put more good people on the project. If you don't have those people, then you've overstated your abilities in the...

The point from the previous post is worth checking out but the original error message does contain the line :

2008-06-13 08:45:15.78 *** Error:...