Create An Instruction manual on how to perform the tasks
$30-250 SGD
En curso
Publicado hace más de 10 años
$30-250 SGD
Pagado a la entrega
Hi we need to have a user manual on how to create and do the following task
1. Log on to the local server.
2. Open Microsoft SQL Server Management Studio and connect to local developer server .
3. Create a new SQL Server Management Studio scripts project.
4. Set the AdventureWorks2008 database recovery model to Full and script the action to the [login to view URL] file.
5. Create a folder in the C:\ that will be used to hold the backups.
6. Create backup devices that will be used to hold full, differential, and log backups of the Adventureworks database and script the action to the [login to view URL] file.
7. Back up the AdventureWorks2008 database to the BackupFull device with compression and script the action to the [login to view URL] file.
8. Back up the AdventureWorks2008 log to the BackupLog device with the overwrite option and script the action to the [login to view URL] file.
9. Perform a differential backup of the AdventureWorks2008 database to the BackupDiff device with the overwrite option and script the action to the [login to view URL] file.
10. Backup the AdventureWorks2008 log to the BackupLog device with the append option and script the action to the [login to view URL] file.
10. Add a new query to the AW_Recovery project.
11. Update the [login to view URL] table.
12. Simulate a disaster of the Adventureworks2008 database.
13. Perform a tail log backup of the AdventureWorks2008 database and script the action to the [login to view URL] file.
14. Perform a restore of the AdventureWorks2008.
15. Verify that the AdventureWorks2008 file has been restored.
16. Add a new query to the AW_Recovery project.
17. Create a database snapshot of the AdventureWorks2008 database.
18. Verify the same data is retrieved from the AdventureWorks2008 database and the AdventureWorks2008_Snapshot database snapshot.
19. Remove the [login to view URL] table in the AdventureWorks2008 database.
20. Confirm that the [login to view URL] table in the AdventureWorks2008 database has been removed.
21. Restore the [login to view URL] table by restoring the AdventureWorks2008 database from the AdventureWorks2008_Snapshot database snapshot.
22. Restore the [login to view URL] table by creating a create table script of the table in the AdventureWorks2008_Snapshot database snapshot and executing the script against the AdventureWorks2008 database.
23. Insert data into the [login to view URL] in the AdventureWorks2008 database from the [login to view URL] in the AdventureWorks2008_Snapshot database snapshot.
24. Confirm that the [login to view URL] table in the AdventureWorks2008 database has been removed.
25. Log on to the LOCAL SERVER server by using the Administrator login.
26. Open Microsoft SQL Server Management Studio and connect to LOCAL SERVER .
27. Create a new SQL Server Management Studio scripts project.
28. Add a new query to the AW_Recovery project.
29. Create backup device that named BackupMaster script the action to the [login to view URL] file.
30. Back up the master database and script the action to the [login to view URL] file.
31. Prepare to restore the master database.
32. Restore the master database.
33. Verify that the master database has been restored.