How to backup couchbase buckets and upload to S3.
This script can be configured in cron job to scheduled to run hourly and i will create one repo every
–DB Blog
This script can be configured in cron job to scheduled to run hourly and i will create one repo every
–Create Triggers for protection SET NOCOUNT ON ;With AllTables as (SELECT NAME, SCHEMA_NAME(t.[schema_id]) AS SchemaName FROM sys.tables AS t WHERE t.is_ms_shipped = 0 ) SELECT ‘CREATE TRIGGER tr_’ + SchemaName + ‘_’ + NAME + ‘ ON [‘ + SchemaName
Remove Grep if you want to list or keep it for search and example here search by name with ‘db’
aws s3 ls –summarize –human-readable –recursive BucketName |grep “Total Size”
dmesg | grep -i numa
All Couchbase logs are stored in this location in Linux based systems. /opt/couchbase/var/lib/couchbase/logs
DECLARE @DB_Name varchar(100) DECLARE @Command nvarchar(2000) DECLARE database_cursor CURSOR FOR SELECT name FROM sys.databases where database_id>4 and name not like ‘%master%’ OPEN database_cursor FETCH NEXT FROM database_cursor INTO @DB_Name WHILE @@FETCH_STATUS = 0 BEGIN SELECT @Command =’ use ‘+ @DB_Name+’; declare @query varchar(1000) declare @executequery cursor set @executequery=cursor for select ” sp_change_users_login ”+CHAR(39)+”update_one”+
–Script to failover all databases in a instance. declare @mirroring table (query varchar(200)) insert into @mirroring select ‘use master;’ insert into @mirroring SELECT ‘ ALTER DATABASE ‘+quotename(db_name(database_id))+’ SET PARTNER FAILOVER ;’ FROM sys.database_mirroring WHERE mirroring_role_desc = ‘PRINCIPAL’ select * from @mirroring — Script to Remove
Sometimes there will be the requirement to delete million rows from a multi million table, as it is hard to
When installing sql server update or service pack, one of the reason to fail if you have