Find Jobs
Hire Freelancers

Create An Instruction manual on how to perform the tasks

$30-250 SGD

In Progress
Posted almost 11 years ago

$30-250 SGD

Paid on delivery
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.
Project ID: 4714334

About the project

1 proposal
Remote project
Active 11 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
I can help you, please check you Inbox.
$250 SGD in 5 days
4.8 (17 reviews)
4.8
4.8

About the client

Flag of SINGAPORE
Singapore, Singapore
5.0
7
Member since Oct 28, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.