I wish to use the gui to detach and reattach a DB, this in itself is no problem and works fine. However I want to be able to move the MDB file to one location and the LDF to another. The detach/reattach process only allows me to put the MDF/LDF to the same location.
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
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…