Well, technically it is possible to shrink a mirrored LOG. What is doing trouble is to backup log with truncate_only. Mirroring doesn’t accept it. So one way is to perform a backup log to disk: USE [DATABASE_NAME]; BACKUP DATABASE [DATABASE_NAME] TO DISK=’E:\Backup\DATABASE_NAME_FULL.bak’ WITH FORMAT; CHECKPOINT; WAITFOR DELAY ’00:00:02′; BACKUP LOG [DATABASE_NAME] TO DISK = ‘E:\Backup\DATABASE_NAME_TL.trn’;… Continue reading Shrinking the transaction log of a mirrored SQL Server 2014 database
AlwaysOn is a great new feature to SQL Server 2012 that allows consuming clients to have a mirroring and failover database solution all transparently for a single named instance. SharePoint is one such consumer of SQL and depends on having a solid connectivity to run. If SQL goes down, so does SharePoint so it’s well… Continue reading SharePoint 2013 and SQL Server AlwaysOn – High Availability SharePoint
Many a times we may need to get the Time, Hour, Minute, Second and Millisecond Part from DateTime in Sql Server. In this article we will see how we can get these parts of the DateTime in Sql Server. You may like to read the other popular articles on Date and Time: How to get… Continue reading How to get Time, Hour, Minute, Second and Millisecond Part from DateTime in Sql Server
I have a table of students: id | age ——– 0 | 25 1 | 25 2 | 23 I want to query for all students, and an additional column that counts how many students are of the same age: id | age | count —————- 0 | 25 | 2 1 | 25 |… Continue reading Count occurrences of a column value efficiently in SQL
how to get the middle string you need something like that declare @text varchar(64) set @text = ‘123|456|798’ SELECT SUBSTRING(@text,CHARINDEX(‘|’, @text) + 1,LEN(@text) – CHARINDEX(‘|’, @text) – CHARINDEX(‘|’, REVERSE(@text)) )
1) This is the best Solution. First of all run following T-SQL Query in Query Analyzer. This will return all the existing users in database in result pan. USE YourDB GO EXEC sp_change_users_login ‘Report’ GO Run following T-SQL Query in Query Analyzer to associate login with the username. ‘Auto_Fix’ attribute will create the user in… Continue reading SQL Server 2012 Error 15023 : User already exists in current database.
If you will ever be in need to have list that shows your all databases that you have in your sequence server. just use this simply query : GO SELECT name, database_id, create_date FROM sys.databases ; GO