DD Class14

esse quam videri
Revision as of 02:23, 3 May 2007 by Jeff (talk | contribs)
Jump to: navigation, search


xml and objects

http://iam.colum.edu/dd/classsource/class14/class.aspx -source

Backup and Restore

The data files can be detached from the server

DataBaseTakeOffline.png

Once a databse is detached the data files my be copied to another server. You need to have access to the file system on the data server to do this.

the databse may also be backed up and restored using the Management Studio.

Export

You can backup the work you did on your database by generating an sql script for you database.

GenerateScript.png

this will start the wiazrd to generate sql script

GenerateScriptWizard.png

notice that the genrated scrtip does not contain any data.

You can export the data to an access database.

Start by making an empty access database

homework

finish final project