Hello
We are approaching the "go live" date of a big application upgrade, so while the application is being upgraded i was asked to lock out all users and backup all databases and make sure the data isnt changed during a period of time
fine, no biggie was my first thought....
it turns out, as one of my databases is being replicated to another server, i cant put that database in read_only mode, or restricted_mode, without removing the replication.
removing the replication means i have to set it up again and that means another 3 hours added to an already cram-packed weekend without sleep!
does anyone here have an idea of how i can lock out the users to make sure there are no changes to a database other then read_only/restricted_mode/single_user ?
i really dont want to touch that replication...
thanks!