[dba-SQLServer] Restoring Database from Another server

David Emerson newsgrps at dalyn.co.nz
Thu Dec 14 12:29:28 CST 2006

Thanks Francisco,

The problem was discussed in the thread in the AccessD list called 
"Stored Procedure not producing results".

In summary, I have three versions of a database which are virtually 
identical apart from the data. I have 1 stored procedure which on two 
databases runs within 10 seconds, but on the other takes over 5 
minutes.  When I copied the data from the slow database to one of the 
good ones the procedure runs within 10 seconds (this seemed to 
indicate that it was not the data that was the problem).  I tried to 
compare the design and indexes of the relevant tables and views and 
they seemed identical.  Without spending too much more time on it my 
solution is to replace the slow version with my master copy.


At 15/12/2006, you wrote:
>There are, if you re-created users on each server then the mappings
>for rights won't go over well, You can always run the ophaned user
>script to re-enable this easily or, alternatively migrate user
>information from the source server to the destination, if this was
>done initially then there won't be any problems.  I'm curious tho, you
>say your db may be corrupt, I've seen very few "suspect" dbs on Sql
>Server 2000 what are the symptoms you are experianceing?
>On 12/14/06, David Emerson <newsgrps at dalyn.co.nz> wrote:
> > I sent this to the general list but it seems more appropriate for this one.
> >
> > I am looking at the probability of needing to restore a database from
> > my development computer to a client site (overwriting the old
> > possibly corrupt version).
> >
> > There are users and permisions set up on both computers (they should
> > be identical)
> >
> > Are there any things I should be aware of that may cause problems (eg
> > user and role settings not being compatible across the two computers?)
> >
> >
> > Regards
> >
> > David Emerson
> > Dalyn Software Ltd
> > Wellington, New Zealand
> >
>http://sqlthis.blogspot.com | Tsql and More...
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com

More information about the dba-SQLServer mailing list