Viewing 15 posts - 1 through 15 (of 90 total)
No as illustrated above, instead of $Host.Name on the second one, it was supposed to be $Host.Version.
Good catch.
December 27, 2021 at 4:37 pm
My understanding is that when you restore in standby, it will do the crash recovery for the database and execute the Redo phase and store the Undo phase in the...
April 15, 2021 at 8:01 pm
Thanks. I was really just illustrating that it is a permissions issue with the file. The way I have done it in a demo is to allow permissions to Everyone...
April 15, 2021 at 7:52 pm
When you back up a certificate the file that is created is locked down in permissions (ACL-Access Control List) to the SQL Server Service account only. If you were to...
April 7, 2021 at 4:30 pm
Best Wishes Ken. Haven't seen you in a long time. Stay safe and hope to see you sometime in person. Best to your wife as well. Thanks for all you...
July 8, 2020 at 3:36 am
It is a feature of the Big Data Cluster part of the SQL 2019 Release. It did not make it into the Relational Engine this release. So no system dbs...
February 22, 2020 at 9:22 pm
Yes, I know all of these things. Thanks for the posts. These articles were written years ago. I will see if I can get with Red-Gate and get these updated...
April 27, 2018 at 12:08 pm
And you can certainly run RESTORE HEADERONLY from disk='disk file location' and RESTORE FILELISTONLY FROM disk='path to disk' to get some information about the database backup from the backup files...
March 8, 2017 at 9:33 pm
I just migrated hundreds of databases to new servers and SQL 2016 SP1. I used log shipping with PowerShell that I created to start the process of migration early and...
March 8, 2017 at 9:28 pm
You are using terms that aren't really real. Between SQL and the disks. It is really about the Disks and Buffer Pool (reading from disks into memory) and there is...
March 8, 2017 at 9:15 pm
As has been said it depends on whether your SQL Server services shutdown cleanly. If not there are ways to attach a single file as a database, but it will...
March 7, 2017 at 1:48 pm
CUs will contain patches that are new and important for installation. Some could be contained in CUs, but they are also added to Windows Update and in the Security Bulletins. ...
February 25, 2017 at 10:30 pm
If you renamed your PC, was it before or after the SQL Server was installed? You may also need to do a sp_dropserver 'oldname' and an sp_addserver 'newname', 'local' to...
February 25, 2017 at 9:48 pm
I go into SSMS and expand the Management folder and right click on the SQL Server Error logs and choose Configure.
February 9, 2017 at 10:22 pm
I don't know that you can set it yet. I have the very latest build and it does not let me set it, even with the GUI tools of SSMS.
February 9, 2017 at 10:11 pm
Viewing 15 posts - 1 through 15 (of 90 total)