Francisco Tapia
fhtapia at gmail.com
Tue Jan 2 18:47:29 CST 2007
David, I'm sorry that I've taken too long to reply, hopefully, it was not too much of a problem. When you already have users on a destination server it is no longer necessary to re-apply them, they are already there. I've seen "slow" Databases but that is generally an architecture problem. That is, Your HDD may be too slow, on the server w/ the slowest response. If you're running all of this on the same server but the last version of the DB is slow then I would take a look at the physical fragmentations, stop the service if you are able to (non-production servers) and run the Defrag utility in windows, this usually will do the trick. Other problems for very slow db response times can be because you have the page file on the same disk as the database, or you do not have enough ram, and the results you are expecting are too large. On 12/14/06, David Emerson <newsgrps at dalyn.co.nz> wrote: > The users we want are the existing ones on the destination server, > not the source server. They already exist for another database on > the destination server. Will I need to save the current users on the > destination server and reapply them once the database is restored? > > David > > 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? > > > >ref: > >http://sqlthis.blogspot.com/2006/01/migrating-logins-from-one-sql-server.html > > > > > >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 > > > > > > > > > > >-- > >-Francisco > >http://sqlthis.blogspot.com | Tsql and More... > >_______________________________________________ > >dba-SQLServer mailing list > >dba-SQLServer at databaseadvisors.com > >http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > >http://www.databaseadvisors.com > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > > -- -Francisco http://sqlthis.blogspot.com | Tsql and More...