3770170
Description
Mind Map by Ernesto Davalos, updated more than 1 year ago
|
Created by Ernesto Davalos
over 8 years ago
|
|
Administración de usuarios y
mantenimiento de bases de datos
- CREATE LOGIN "Crear usuario"
- WITH PASSWORD = "asignar Contraseña"
- WITH PASSWORD = "asignar Contraseña"
- ALTER USER "Modificar usuario"
- WITH "NOMBRE DEL CAMPO" = "PARAMETRO"
- WITH "NOMBRE DEL CAMPO" = "PARAMETRO"
- DROP USER user_name "Eliminar usuario"
- RESPALDO
- BACKUP DATABASE = "nombre de la base de datos"
- TO DISK = "Direccion donde se almacenara"
- WITH FORMAT "formato"
- MEDIANAME =" Nombre"
- NAME =" Nombre del archivo"
- NAME =" Nombre del archivo"
- MEDIANAME =" Nombre"
- WITH FORMAT "formato"
- TO DISK = "Direccion donde se almacenara"
- BACKUP DATABASE = "nombre de la base de datos"
- REORGANIZAR INDICE
- ALTER INDEX ALL ON "Nombre de la base de datos"
- REORGANIZE ;
- REORGANIZE ;
- ALTER INDEX ALL ON "Nombre de la base de datos"
- REDUCIR BD
- DBCC SHRINKDATABASE (BASE DE DATOS PORCENTAJE)
- DBCC SHRINKDATABASE (BASE DE DATOS PORCENTAJE)
- LIMPIAR HISTORIAL
- Grupos
- CREATE ROLE [ ]
- ALTER AUTHORIZATION ON SHCHEMA::[BD] TO [ Rol ]
- GRANT INSERT ON [ BD] TO [ROL]
- GRANT DELETE ON [BD] TO [ROL]
- GRANT SELECT ON [BD ] TO [ROL]
- GRANT UPDATE ON [BD] TO [ROL]
- GRANT UPDATE ON [BD] TO [ROL]
- GRANT SELECT ON [BD ] TO [ROL]
- GRANT DELETE ON [BD] TO [ROL]
- GRANT INSERT ON [ BD] TO [ROL]
- ALTER AUTHORIZATION ON SHCHEMA::[BD] TO [ Rol ]
- CREATE ROLE [ ]
Media attachments
Want to create your own Mind Maps for free with GoConqr? Learn more.