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
You must be logged in to post a comment.