Find Jobs
Hire Freelancers

Create An Instruction manual on how to perform the tasks

$30-250 SGD

処理中
投稿日: 11年近く前

$30-250 SGD

完了時にお支払い
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.
プロジェクト ID: 4714334

プロジェクトについて

1個の提案
リモートプロジェクト
アクティブ 11年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
アワード者:
ユーザーアバター
I can help you, please check you Inbox.
$250 SGD 5日以内
4.8 (17 レビュー)
4.8
4.8

クライアントについて

SINGAPOREのフラグ
Singapore, Singapore
5.0
7
メンバー登録日:10月 28, 2011

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。