copy of sql server database
-
Hi does any1 know how to copy sql database. I need to make another version of the database for test purposes thanks
Take a backup and restore it to a new database... You can do this form SQL Server Management Studio For MS SQL Server/MS SQL Server Express, from Enterprise Manager for MS SQL Server 2000 and 7.0. From Query Analyzer, SQLCMD or other sql tools; lookup BACKUP (T-SQL) and RESTORE (T-SQL) in books online or Google.
-
Hi does any1 know how to copy sql database. I need to make another version of the database for test purposes thanks
Hi, Open Sql Server 2000 Enterprise Manager Select Your DataBase Right Click on that there is an option Under All Tasks->BackUp DataBase->In Destination Path Give The Location Where u want to store that database back up. After that Click Ok. Then Restore this database backup where ever you want. For that Just create one database Right Click on that Select All Tasks->Select Restore Database,Select From Device It will ask the location there u specify ur DataBase Backup Name Click Ok. Regard's Veeresh
i want to join this group
-
Hi does any1 know how to copy sql database. I need to make another version of the database for test purposes thanks
Hi, Open Sql Server 2000 Enterprise Manager Select Your data base Right Click on that there is an option Under All Tasks->BackUp data base->In Destination Path Give The Location Where u want to store that database back up. After that Click Ok. Then Restore this database backup where ever you want. For that Just create one database Right Click on that Select All Tasks->Select Restore Database,Select From Device It will ask the location there u specify ur DataBase Backup Name Click Ok. Regard's Veeresh
i want to join this group