September 6, 2003 at 2:06 am
Hi, On copying database files and attaching to another Sql server constraints are not getting .plz help
Edited by - koithodan on 09/20/2003 06:23:57 AM
September 6, 2003 at 4:57 am
You can use backup/restore or sp_attach_db, look in BOL for syntax
HTH
Ray Higdon MCSE, MCDBA, CCNA
------------
Ray Higdon MCSE, MCDBA, CCNA
September 7, 2003 at 12:18 pm
Either way you should get all your constraints. If you copy objects with DTS instead of selecting the entire db, you could miss them that way.
Andy
September 8, 2003 at 5:51 am
Take a complete backup of the database and then restore it on to the destination server...this will take care of u'r problem.
September 20, 2003 at 6:25 am
thanx all. it's working perfectly
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply