Technical Article

RE: Log Shipping from SP2 to SP3

  • Reply

Both servers are on the same domain.No clustering. Both sql services are using same domain admin account now. Previously local admin account. Now backup itself fails. Error 3202: Write on\\servername\dirname\dbname_logshipping_init.bak failed status=64


Technical Article

RE: Copy Jobs between servers

  • Reply

If there's a lot of jobs to be scripted, right-click on JOBS in the EM tree and then 'All Tasks' then Generate SQL Scripts. You can manually edit out unwanted jobs from the script before executing it. Note: I also uncheck "Replace job if it exists" in most cases. This saves my hide if I […]


1 reads

Technical Article

RE: Join of 2 tables to create a 3rd

  • Reply

Yep, your analysis is correct. There are two ways depending on the data. 1. Is description and budget_version always the same for one project? In this case, you can use SELECT name, min(descrip), min(budget_version) FROM ... GROUP BY name This is in fact tricking SQLServer since you have denormalised tables... 2. The other way is […]



Hyperconverged storage tuning tip for SQL Server


We all (should) know that running SQL Server in hyperconverged virtual environments, both on-premises...

Daily Coping 25 Nov 2022


Today’s coping tip is to connect with someone from a different generation. This tip...

Snowflake Classic UI vs Snowsight


This blog post is not about which User Interface is better, Classic or Snowsight...

Read the latest Blogs


Restore takes forever

By Edvard Korsbæk

Hi all! I have som pretty smal databases - the backup is app. 250...

DML Trigger Limits

By Steve Jones - SSC Editor

Comments posted to this topic are about the item DML Trigger Limits

A week in Seattle in 8 Slides at the PASS Data community Summit 2022

By Tonie Huizer

Comments posted to this topic are about the item A week in Seattle in...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers