Martin Reid
mwp.reid at qub.ac.uk
Tue Aug 16 08:27:00 CDT 2005
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_onmigwiz_0z50.asp Martin ----- Original Message ----- From: "Roz Clarke" <roz.clarke at donnslaw.co.uk> To: <dba-sqlserver at databaseadvisors.com> Sent: Tuesday, August 16, 2005 2:22 PM Subject: [dba-SQLServer] Moving databases (SQL Server 7) > Hi all > > I have 2 databases that I need to transfer from one SQL Server server to > another. I need the data, but I also need the logins, security settings, > maintenance plans, jobs etc. > > Up to now I have only ever used backup and restore to copy databases (data > only) on a single server. > > What is the best way to do this? I have been asked to do it in the next 2 > hours. > > ha ha ha ha ha ha > > TIA > > Roz > -------------------------------------------------------------------------------- > > The contents of this message and any attachments are the property of Donns > Solicitors > and are intended for the confidential use of the named recipient only. > They may be legally > privileged and should not be communicated to, or relied upon, by any other > party without > our written consent. If you are not the addressee, please notify us > immediately so that we > can make arrangements for its return. You should not show this e-mail to > any person or > take copies as you may be committing a criminal or civil offence for which > you may be > liable. The statement and opinions expressed in this e-mail message are > those of the > writer, and do not necessarily represent that of Donns Solicitors. > Although any files attached > to this e-mail will have been checked with virus protection software prior > to transmission, > you should carry out your own virus check before opening any attachment. > Donns Solicitors does not accept any liability for any damage or loss > which may be caused > by software viruses... > -------------------------------------------------------------------------------- > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >