SYNTAXES FOR HOW TO MAKE YOUR DATABASES FULL TO SIMPLE AND SIMPLE TO FULL RECOVERY MODELS

 To make your database in the Full recovery model:

To make your database in the Bulk Logged recovery model:

Comments

Post a Comment

Popular posts from this blog

CREATE VIEW SQL: Modifying views in SQL Server

Image
Introduction The primary goal will be to get familiar with the  ALTER VIEW  command used to modify views and change the output. A view is based on the result set from a query, and this command allows us to change the structure and definition of a query. Ironically, before modifying a view, we will create another view with a bit more complex T-SQL using aggregates in it rather than having a simple SELECT statement that is pulling everything from a table. We will not go over the syntax again since T-SQL is exactly the same as in CREATE VIEW SQL statement except the fact that instead of the CREATE reserved keyword ALTER is used. Creating view As I mentioned earlier, let’s use the code from below to create a bit more complex view: 1 2 3 4 5 6 7 8 9 10 11 CREATE VIEW vTop3SalesByQuantity AS      SELECT TOP 3 --will only return first 3 records from query      Sales . ProductID ,      Name AS ProductName ,  ...
Read more

Missing MSI’s/MSP’s error during SQL Server Patching

Image
  Missing MSI’s/MSP’s error during SQL Server Patching Missing MSI’s/MSP’s errors will be coming    1. while Applying Service packs   2. While Installing SQL Server instance (another instance in same box)  Reason: As the error states a possible Windows Installer database file (.msi) or the Windows Installer patch file (.msp) is missing from the Windows Installer cache. This normally occurs when the setup is stopped mid-way or due to file corruptions.  Also As part of C drive space management windows team used to delete files from folder ‘ C:\windows\Installer\’   where our SQL Server instance dependent  MSI/MSP files are located. so if these files are deleted we will get MSI/MSP files missing errors while applying SQL Service packs (or) doing another Instance of SQL Server in the same server  Fix: Below is an amazing support link by Microsoft which explains the cause and resolution for the above error. It also provides a vb script...
Read more

SQL Server Permissions List for Read and Write Access for all Databases

Image
  Problem For compliance auditing, a customer asked for a list of users who have read or write access in any database on the SQL Server instance. Although there are several tables that can provide us the information, the permissions can be at the instance level or at the individual database level.  Further, the permissions can be granted through a role, a role that is member of another role or directly to a login or database user, so it requires some time to prepare the report. Solution The script below gives you the requested information in a small amount of time. For example, in one server with 25 databases it completed in 14 seconds. When it is run in the whole registered servers through a multi-server query (85 instances and 335 databases), it took 5 minutes and 38 seconds to return 10,372 rows with all the information. SQL Server Permissions Script Below is the script. ; WITH [ explicit ] AS ( SELECT [ p ].[ principal_id ], [ p ].[ name ], [ p ].[ type_desc ], ...
Read more