I have a MS SQL server with separate system, data and log drives. My data drive is getting tight on space, so I added a new drive to the server. Now I need to know how to add the new drive to SQL server so it can be used, and move some databases to it. How do I accomplish this?
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed