Find Jobs
Hire Freelancers

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.
ID del proyecto: 4714334

Información sobre el proyecto

1 propuesta
Proyecto remoto
Activo hace 11 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
I can help you, please check you Inbox.
$250 SGD en 5 días
4,8 (17 comentarios)
4,8
4,8

Sobre este cliente

Bandera de SINGAPORE
Singapore, Singapore
5,0
7
Miembro desde oct 28, 2011

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.