This tip is about the SQL Server Management studio again.
Many Dynamics Nav customers and consultants are very new to SQL and the programming language T-SQL.
The SQL Server has solved that with introducting tons of wizards for common tasks like backing up databases and creating users.
Let's look at one of those (Backup);
With this wizard we can easily create a full, incremental or transaction log backup of the database.
Without going in the details about this wizard I would like to point out the script button
This button exists on a lot of SQL Server wizards. When you push it you get this in your query window
You can use this to either study T-SQL or create your own scripts to reuse or schedule!