[dba-SQLServer] Restoring Database from Another server

David Emerson newsgrps at dalyn.co.nz
Tue Jan 2 18:58:59 CST 2007


Francisco,

Thanks for the reply.  The problem seems to have solved itself over 
the holidays.  The IT team did some work on the server so they may 
have defraged the database.

However, I will file away your suggestions for the future.

Regards

David

At 3/01/2007, you wrote:
>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...
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com




More information about the dba-SQLServer mailing list