All that IT stuff you normally forget as you go along and spend ages trying to remember...
Run the following script to list the Recovery Model setting for all DBs in MSSQL
SELECT Name, DATABASEPROPERTYEX(Name,'RECOVERY') AS [Recovery Model] FROM master.dbo.sysdatabases
No comments:
Post a Comment