backup and restore SQL server 2000
Not what you're looking for?
The objective of this 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, and pasting into your homework document.
Perform backups of the database you created in Unit 2 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 in Unit 2, 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. Also submit the actual backup files that were created. If you accepted the default locations, they should be located at C:SQLServerMSSQLBACKUP
Purchase this Solution
Solution Summary
Details about using tools to backup/restore sql server 2000.
Purchase this Solution
Free BrainMass Quizzes
Basic Computer Terms
We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.
Word 2010: Tables
Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.
C# variables and classes
This quiz contains questions about C# classes and variables.
C++ Operators
This quiz tests a student's knowledge about C++ operators.
Java loops
This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.