Alternatively, back up the DB on the work server, copy the Bakup file to CD
At home, create a new DB in Enterprise Manager, then restore the DB from the CD. hth paddy ----- Original Message ----- From: "Paul Fennell" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, September 16, 2003 4:12 PM Subject: RE: [ cf-dev ] OT SQL 2000 Database copy Ah If you have enterprise manager at home you should be able to connect to your work sql server with a user account . ( you can get the sql server tool kit from msdn ) Create the new db local on your pc and use dts to import the data from your work db/client Just make sure before you leave that you take a user.pass login that is valid :) And the ipaddress etc - ( that goes with outsaying that the db isn’t protected by routing .. ie only the webserver ip canconnect to the sql server _) -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 16 September 2003 15:51 To: [EMAIL PROTECTED] Subject: [ cf-dev ] OT SQL 2000 Database copy Please forgive the ignorance but I have never done this before. I need to copy a database on SQL2000 so that I can burn it on to CD and put it on my server at home. How do I do this? Do I need to copy lots of files or will Enterprise Manager make it nice & easy for me ? Regards - Paul ************************************************************************ ************************* The information contained within this e-mail (and any attachment) sent by Birmingham City Council is confidential and may be legally privileged. It is intended only for the named recipient or entity to whom it is addressed. If you are not the intended recipient please accept our apologies and notify the sender immediately, or telephone +(44) 121 303 6666. Unauthorised access, use, disclosure, storage or copying is not permitted and may be unlawful. Any e-mail including its content may be monitored and used by Birmingham City Council for reasons of security and for monitoring internal compliance with the office policy on staff use. E-mail blocking software may also be used. Any views or opinions presented are solely those of the originator and do not necessarily represent those of Birmingham City Council. We cannot guarantee that this message or any attachment is virus free or has not been intercepted and amended. ************************************************************************ ************************* -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.518 / Virus Database: 316 - Release Date: 11/09/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.518 / Virus Database: 316 - Release Date: 11/09/2003 -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] _____________________________________________________________________ This e-mail has been scanned for viruses by MCI's Internet Managed Scanning Services - powered by MessageLabs. For further information visit http://www.mci.com -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
