SQL Server Performance Forum – Threads Archive
creating exactly same DBhi I have to create a DB on a "testing machine" exactly same as the production server( to test some
application before applying it on production server)
what are the steps to do this. thank you
Take full backup from production server and restore on test machine, refer to books online for BACKUP/RESTORE topics for more information. If the both machines can see each other simple task to create DTS package or use COPY DATABASE wizard to copy the database in full. _________
Don’t forget to run update statistics after restore on test machine. Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
…true.. thanks for the makeup Luis. _________