what that means is the wizard expects you to have already restored the databse on the secondary in norecovery mode.

mstoffa,

I went through the process as described , applying hf2187 and then 2273, but still get an error running an addalias.

have you proved that adding the hotfix for 2145 only...

I would need to test this to confirm which will take a while, so please do your uninstalls etc on your test box first!

One clarification, once you are at straight...

if exists (select 1 from msdb..backupset where database_name = 'blah' and type = 'D')

i.e. history of backups is kept in backupset table in msdb.

pls check column names, no access to...

you forgot unzip 🙂

apologies, brain freeze, mirrored snapshots would be read only as well......................

if the developers are ok with the database being read_only log shipping will work for you. Just choose the option to restore the logs in standby mode, then the database...

thats good to hear, were you able to confirm it resolves your problem on the VM box?

you cannot restore reportserver.mdf using reportservertempdb.mdf, these are the data files from two different databases.

without a backup you cannot get the database back.

Best now to go through all your other...

I have not come across the problem but think I can take an educated guess at the cause and way round it. The update being applied by WSUS (god bless...

kevin.deutschman (12/2/2008)

---

If I am reading from the last to posts correctly it sounds as if the logins sids that are attached to the DBs are not matching the original sids...

have you transferred the logins as well? sp_help_revlogin is best for this in your scenario, will avoid need for sp_change_users_login as it brings across the sid as well. there is...

the transaction log is used for recovery so will contain lots of other data rather than just the pure insert, such as who inserted it, when, the lsn, markers for...

can you expand on the error a bit? Are the users losing all access to the database? As you are moving the databases to a new server the users may...

main effect is that SQL can not perform any actions that require network connectivity, e.g. access shares on other servers, backup across the network, logshipping or mirroring would not work...