Copies of .MDF and .LDF files for SQL Server versions 7.0 can be made with any reliable utility as long as the database is shut down when the copy is made.
Detaching and reattaching is the proper way of doing it yes But you often cant on a live db.. If its just for development testing and you are unable to shut the db down Using enterpize manager to import the data is a handy method to grab a live db The best method if we are going to be picky is the dump/load It can be done while the database is up and even while it is being updated. It allows backup and/or recovery of individual databases separately. If a db is copied while SQL Server is still running, many updated pages might not yet have been written to disk, resulting in an inconsistent image of the database. This is why DUMP/LOAD goes through SQL Server rather than accessing the disk files directly. -----Original Message----- From: Paul Johnston [mailto:[EMAIL PROTECTED] Sent: 16 September 2003 16:25 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] OT SQL 2000 Database copy > Please forgive the ignorance but I have never done this before. np > 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? Assumption: BIG database that needs a CD This means that you have 2 options: 1) Backup of Database Problem with this is it backs up the data file paths too... This can be changed when you "restore" the database in enterprise manager, but it's easy to forget 2) Detach Database and Attach Database "Proper" way of doing it, because it gives you a current snapshot of the database. First find out where the data files are (properties of the database) and then detach, copy the files, re-attach the database. That way the DB can't be changed! 1 is usually sufficient though! Paul -- ** 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]
