just take a backup of your data source and restore it on another machine. for that just type this query and run it.
backup database <db name> to disk = '<destination path>' for restoring database restore database <db name> from disk = '<destination path>' also you can attach and detach the database for that right click on database, go to all task and detach it. then just copy the database files. you must copied both file. and copy it agiain in other machine. again attach the database same way right click on database and attach it. -- To unsubscribe, reply using "remove me" as the subject.
