MSSQL Server maintenance
Find the physical location select name, physical_name from sys.database_files Backup and shrink use DBnamego alter database DBnameset recovery simplegoDBCC SHRINKFILE (DB_Log_Name,2) — MSSSNTI_log is …
Database
Identify blocking query and kill blocking_session_id in mssql server
Identify the blocking query by executing below SQL SELECTdb.name DBName,tl.request_session_id,wt.blocking_session_id,OBJECT_NAME(p.OBJECT_ID) BlockedObjectName,tl.resource_type,h1.TEXT AS RequestingText,h2.TEXT AS BlockingTest,tl.request_modeFROM sys.dm_tran_locks AS tlINNER JOIN sys.databases db ON db.database_id = tl.resource_database_idINNER …
Identify blocking query and kill blocking_session_id in mssql server Read More »
Backup and restore mysql database using mysqldump
To backup: mysqldump -u root -p liveDBname > backup.sqlmysqldump -u root -p liveDBname > backup-$(date +%Y-%m-%d-%H).sqlmysqldump -u root -p liveDBname > backup-$(date +%Y-%m-%d-%H.%M.%S).sql To …
Backup and restore mysql database using mysqldump Read More »