> 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]
