Create multiple backups of databases


Assignment:

The objective of assignment to is create multiple backups of databases and then to restore the databases from the backups you've created.

It is essential that you take screen shots and give explanations of the steps performed for each the steps, so that your instructor can see the process and choices you've made along the way.

NOTE: You can easily create a screen shot by pressing the Print Screen button at the top right of your keyboard

Perform backups of the database you created and the Northwind database (remember to take screen shots as you perform these steps).

Perform a Full Database Backup of the Northwind database, using the Enterprise Manager. Name this backup [YourName]_WindBackup_EM.

Create a table named U4_Table, in the database you created with two columns called Name and Date. Add a row in this table with your name and today's date.

Create another table also named U4_Table, in the Northwind database, with two columns called Name and Date. Add a row in this table with your name and today's date.

Perform a Transaction Log backup of your database from (1.b) above. Name the backup [YourName]_[TableName]_transLogBackup.

Perform a Full Database Backup of the Northwind database, using T_SQL. Name this backup [YourName]_WindBackup_TSQL.

Delete the Northwind database, which now should include U4_Table.

Perform a restore of the Northwind database from [YourName]_WinBackup_TSQL

Name the restored database nWindRestored.

Reminder: Make sure to include a screen shot showing U4_table. Click on tables on the left pane and you may have to scroll all the way to the bottom to see U4_Table.

Perform a restore of the Northwind database from [YourName]_WinBackup_EM

Name the restored database Northwind. (You now have your original DB)

Your assignment should include the screen shots and explanations in a Word document.

Solution Preview :

Prepared by a verified Expert
Database Management System: Create multiple backups of databases
Reference No:- TGS01939185

Now Priced at $25 (50% Discount)

Recommended (93%)

Rated (4.5/5)