Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- *PARA BANCO SEX EXPANDIR* (OBS: DEVE-SE SUBSTITUIR ONDE EXISTE O NOME BDCOMERCIAL PARA O NOME DO BANCO A SER TRATADO)
- EXEC sp_resetstatus 'BDComercial';
- ALTER DATABASE BDComercial SET EMERGENCY
- DBCC checkdb('BDComercial')
- ALTER DATABASE BDComercial SET SINGLE_USER WITH ROLLBACK IMMEDIATE
- DBCC CheckDB('BDComercial', REPAIR_ALLOW_DATA_LOSS)
- ALTER DATABASE BDComercial SET MULTI_USER
- *PARA BANCO EXPANDINDO POREM COM ERROS*
- ALTER DATABASE BDComercial SET SINGLE_USER WITH ROLLBACK IMMEDIATE
- DBCC CheckDB ('BDComercial', REPAIR_ALLOW_DATA_LOSS)
- DBCC CheckDB ('BDComercial', REPAIR_rebuild)
- DBCC CheckDB ('BDComercial')
- sp_dboption 'BDComercial', 'single user', 'false'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement