ALTER DATABASE [DBName] SET EMERGENCY; GO ALTER DATABASE [DBName] set single_user GO ALTER DATABASE [DBName] set single_user GO DBCC CheckDB (‘[DBName]’) WITH ALL_ERRORMSGS GO ALTER DATABASE [DBName] SET OFFLINE…
ADMAzevedo Posts
EXEC sp_MSforeachdb ‘IF ”?” NOT IN(”master”, ”model”, ”msdb”, ”tempdb”) BEGIN USE [?] EXEC sp_changedbowner ”sa” END’
SELECT SERVERPROPERTY(‘Servername’) AS ‘Servidor’, msdb.dbo.backupset.database_name As ‘Database’, CASE msdb..backupset.type WHEN ‘D’ THEN ‘Database’ WHEN ‘L’ THEN ‘Log’ WHEN ‘I’ THEN ‘Diferencial’ WHEN ‘F’ THEN ‘File ou Filegroup’ WHEN ‘G’…
All commands should be run from an elevated command prompt. dism /online /cleanup-image /scanhealth dism /online /cleanup-image /checkhealth dism /online /cleanup-image /restorehealth Mount the Windows Server 2016 ISO as…
1. Use “Shift + Restart” on the Windows 10 Sign In screen 2. Interrupt the normal boot process of Windows 10 three times in a row 3. Use a…
On the server, open a CMD.EXE prompt and type: dsquery * domainroot -filter “(&(objectCategory=Person)(objectClass=User))” -attr distinguishedName sAMAccountName whenCreated -Limit 0 I got a list of my AD users with…
Boot with a Installation or Repair disc or USB drive – issue these from the Command Prompt and hit ENTER after each. C: bootrec /fixmbr bootrec /fixboot bootrec /scanos…