Jul 31, 2013 · 1-SQL server authentication - if we are using SQL server authentication then first click on connect to server option in SSMS then we got a small window. in this window we …

Sep 12, 2014 · If SQL Server is installed on the same computer where SharePoint is installed, then try to connect using “.\SHAREPOINT” (without quotes). If SQL Server and SharePoint are …

May 10, 2007 · There is only a Primary server running Win Server 2003 withe Service pack 2 and SQL Server 2005 with service pack 2 and one secondary server runnung Win Server 2003 R2 …

Mar 28, 2016 · SQL Server 2014 with 1 default instance in a failover cluster of 2 nodes. We finally got another drive for the SQL server and want to move the transaction logs to this drive.

Jun 19, 2012 · Physical Log and Logical log in SQL Server : Each time you insert, update or delete a row a logical log record containing information about what was changed and how is …

Jun 22, 2013 · One day i opened the Log file folder in C:\program files\SQLServer 2012\SQL\Log, I was surprised to see the size was more than 1 GB, Although I have put a job in the agent …

Mar 8, 2018 · Question 0 Sign in to vote hi is there away to concatenate string using json SQL 2016 as we are using xml Path ref: https://www.red-gate.com/simple-talk/sql/t-sql ...

Oct 20, 2015 · I have set up log shipping on a SQL 2014 server to copy data from a primary to a secondary server. This is all working correctly backing up, copying and restoring however the …

Oct 12, 2010 · Are you guys setting the max size as unlimited for a logfile ? If thats the case , then this is by design. When you set the log file size to unlimited it gets reset to 2TB which is the …

May 22, 2018 · The master log location is missing from the Parameters registry key.