Find DataBase Backup Modes
This is just a quick method to determine the backup mode of all databases on a server. No cursor involed.
2007-05-18 (first published: 2007-05-07)
412 reads
This is just a quick method to determine the backup mode of all databases on a server. No cursor involed.
2007-05-18 (first published: 2007-05-07)
412 reads
Here's the scenario: 1. You have been given a script to run.2. You do not know the database name.3. You know which server.Substitute the word "TABLENAME" with the table name in the script and run in query analyzer. This query will check every database on the server and return the name of the database with […]
2007-04-26 (first published: 2007-04-04)
459 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
This is one of those things that on hindsight was a stupid problem, but...
Hi All, We have Project server 2019 (Sharepoint). The database server (Only Database services...
Hi Everyone, Good morning. I am new to Sql administration.Have one question. We work...
Hello. I am not a SQL Developer - just an IT generalist (if that)...