Mantenimiento a la bdd.
Mantenimiento a la bdd.
1. Respaldar empresa.
2. Conectarse a Management.
3. Sobre la base de datos aplicar querys de mantenimiento:
EXEC SP_RESETSTATUS 'ctEMPRESAX';
DBCC CHECKDB('ctEMPRESAX')
ALTER DATABASE ctEMPRESAX SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CHECKDB ('ctEMPRESAX', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE ctEMPRESAX SET MULTI_USER
ALTER DATABASE ctEMPRESAX SET ONLINE
DBCC CHECKDB ('ctEMPRESAX') WITH ALL_ERRORMSGS
DBCC CHECKALLOC ('ctEMPRESAX') WITH ALL_ERRORMSGS
DBCC CHECKCATALOG ('ctEMPRESAX')
DBCC CHECKFILEGROUP ('ctEMPRESAX') WITH ALL_ERRORMSGS
USE ctEMPRESAX
EXEC sp_resetstatus 'ctEMPRESAX'
4. Sobre la base de datos Reindexar:
DECLARE @TableName varchar(200)
DECLARE TableCursor CURSOR FOR
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
OPEN TableCursor
FETCH NEXT FROM TableCursor INTO @TableName
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT 'Reindexando ' + @TableName
DBCC DBREINDEX (@TableName)
FETCH NEXT FROM TableCursor INTO @TableName
END
CLOSE TableCursor
DEALLOCATE TableCursor
5. Cerrar Management.
Nuestros expertos certificados pueden guiarte paso a paso
Contactar soporte