Introducing
Your new presentation assistant.
Refine, enhance, and tailor your content, source relevant images, and edit visuals quicker than ever before.
Trending searches
Admin Databases Week 5
Admin Databases
Week 5
Databases used in application
SQL is widely used in multiple applications.
Databases are used in web development, applications, cloud computing, and virtualization just to name a few.
Application interfacing
Accounting applications
Accounting
An accounting system is a custom database application used to manage financial data. Custom forms are used to record assets, liabilities, inventory and the transactions between customers and suppliers. The income statements, balance sheets, purchase orders and invoices generated are custom reports based upon information that is entered into the database.
CRM Applications
A customer relationship management system (CRM) is another example of a database application that has been customized to manage the marketing, sales, and support relationships between a business and it's customers.
CRM
Web applications
Web
Many contemporary web sites are built using several database applications simultaneously as core components.
These Web sites also combine an accounting database system to record sales transactions and a CRM database application to incorporate feedback and drive a positive customer experience
SQL Back ups
Back ups
Query BACK UPS
As a database increases in size, full database backups take more time to complete and require more storage space.
For large databases, consider supplementing full database backups with a series of differential database backups.
Estimate the size of a full database backup by using the sp_spaceused system stored procedure.
Event log
Event logs
By default, every successful backup operation adds an entry in the SQL Server error log and in the system event log. If you back up frequently, these success messages will accumulate quickly, resulting in huge error logs!
This can make finding other messages difficult. In such cases, you can suppress these backup log entries by using trace flag 3226 if none of your scripts depend on those entries.
Permissions
Ownership and permission problems on the backup device's physical file can interfere with a backup operation.
The SQL Server service must be able to read and write to the device which means that the account under which the SQL Server service runs must have write permissions to the backup device.
Permissions
sp_addumpdevice
sp_addumpdevice, which adds an entry for a backup device in the system tables, does not check file access permissions.
As a result, problems on the backup device's physical file may not appear until the physical resource is accessed when the backup or restore is attempted.
Back ups as a query
Query BACK UPS
You can use a query that will create a full back up for you.
example
BACKUP DATABASE [learnsql]
TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Backup\learnsql.bak'
WITH NOFORMAT, NOINIT,
NAME = N'learnsql-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
Powershell back ups
You can also use power to back up any of your databases.
$credential = Get-Credential
Backup-SqlDatabase -ServerInstance Computer[\Instance] -Database <myDatabase> -BackupAction Database -Credential $credential
PowerShell
Using Microsoft management tool
With the Microsoft management tool creating a back up is made easy and fast.
All you need to do is right click the database in scroll down to task and select back up.
then you will have a menu box open.
from here you can create your full back ups.
Using MS management tools
Back up Recovery
Recovering your back ups are just as import as doing back ups
we will go over how to recover from a back up.
Recovering back ups
Recovering back ups
The process of recovering a back up is just as simple as creating a back up.
Right click databases folder on object explorer.
From here you click on the restore databases and select which database you would like to recover.