Description of the steps performed for each the steps

Assignment Help Computer Engineering
Reference no: EM1333452

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

Reference no: EM1333452

Previous Q& A

  Define negotiation

Define negotiation

  Infectious disease association

How would I make the case that the Infectious Disease Association of America has market power?

  Challenges for human resource management

What are some future trends and challenges for human resource management and What can HR do to support the organization's strategies for growth and quality? How can technology improve HR decisions

  Optimal fraction of debt

Illustarte out the optimal fraction of debt and the growth rate of the firm. Illustrate out the relationship between the two?

  Elucidate why the us would subsidize the short run

Elucidate why the US would subsidize the short run costs of production for tobacco farmers in foreign countries.

  Strategic or operational role in compliant work environment

Summarize how the new proposed policy supports either the strategic or operational role in maintaining a compliant work environment.

  Explain kentucky fried chicken- supply chain

Explain Kentucky Fried Chicken- Supply Chain and describe the supply chain of Kentucky Fried Chicken Company when in a brick and mortar

  Analyze the importance of hrm''s role

Analyze the importance of HRM's role to manage risk for the organization and give at least two examples that illustrate the application of human resources role

  Calculate a shop forecast of demand

The ABC Floral Shop sold the following number of geraniums during the last 2 weeks. Calculate a shop forecast of demand

  Explain what the database roles

Describe steps necessary to setup SQL Server security.

Reviews

Write a Review

 

Similar Q& A

  Define the way in which a person writes or sends e-mails

explain a scenario in which someone displayed bad netiquette. How did someone react to receiving the email? what could the sender have done differently to display good netiquette.

  Manage the threat, the risk, the disaster

Does one manage an imminent disaster or respond to it? Take a tornado, for example. Is this an imminent disaster waiting to happen? Do you manage the threat, the risk, the disaster or all three.

  Make a public static method named comparescores

Write down a public static method named compareScores that takes two doubles as its arguments and returns the integer value of -1 if the first argument is less than the second, 0 if the first argument is the same as the second, and +1 if the first..

  What address would virtual address 1053 translate to

All numbers are decimal, everything is numbered starting from 0, and all addresses are memory byte addresses. The page size is 1024 bytes.

  Make an initial linked list of students and grades

Modify an existing student in the linked list.make an initial linked list of students and grades.

  How to define the Escape Problem

How to  define the Escape Problem

  Maintenance tracking application for an apartment complex

I dentify 3 variables, along with their types, that I would use in my program. Give a brief description of the variables and see if it contains any reusable components, if so, I am to mention that it does.

  Developing uml one state diagram

How the system responds to the external and/or internal events by developing a UML ONE State Diagram.

  Supply supporting evidence for the decision

Now that you have a normal plan and have identified the information that you need for this program, you feel you are ready to start development. You told your uncle that you would need to purchase software for this program. Since your uncle is in ..

  Program to implement the calculations

Write down a program which has a function named presentValue which carry out this calculation. The function must accept future value, annual interest rate, and number of the years as arguments.

  Determining the output of code

Provide the output of the following given program:#include using namespace std; void fun1 (int *p, int *&q) {*p = 100;p = p + 2;*p = *q; *q = *(p+1);

  Program to determine weighted average of test

Write an algorithm for a program which prompts the user to enter the five test scores, determine total of the five tests and determine the weighted average of each test supposing that each test weighs 20%.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd