Today, we’re going to take a specific, simple example of generating RESTORE LOG statements from a directory list of files, using Powershell and find-and-replace.
Here’s a good starter article on SQL Server logins, users, and SIDs: SQL Server Logins, Users and Security Identifiers (SIDs) Some major points to absorb from this: A login is created at the SQL Server instance level. We say it’s an instance-level object. A user is created at the database level. It’s a database-level object. The SID is the server ID – a […]
This is a basic skill can get overlooked, so let’s talk about a common DBA task: backing a database up and restoring it to another server. First let’s dispel a couple of common misconceptions: You cannot restore a backup from a later version of SQL Server, to an earlier version. For example, a 2016 backup will […]