This should create you a (nearly) duplicate local database you can then backup as you like. ![]() Save the script in a safe place, and go ahead and run it against your new empty database. Create a new local (or remote) database, and change the first 'USE' statement in the script to use your new database. Once it's done its thing, you'll have a backup script ready in front of you. In the next four windows, hit 'select all' and then next,.In 2014: the option to script the data is now "hidden" in step "Set Scripting Options", you have to click the "Advanced" and set "Types of data to script" to "Schema and data" value.In 2012: under 'General', change 'Types of data to script' from 'Schema only' to 'Schema and data'.In 2010: under the Table/View Options, change 'Script Data' and 'Script Indexes' to True and hit next,. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |