Tuesday, 9 June 2020

create a data base with query

create a data base with query
CREATE DATABASE databasename;
CREATE DATABASE testDB;
how to delete the database
DROP DATABASE databasename;
DROP DATABASE testDB;
how to backup the database to anohter place or location
BACKUP DATABASE databasename
TO DISK = 'filepath';
BACKUP DATABASE databasename
TO DISK = 'filepath'
WITH DIFFERENTIAL;
BACKUP DATABASE testDB
TO DISK = 'D:\backups\testDB.bak';
BACKUP DATABASE testDB
TO DISK = 'D:\backups\testDB.bak'
WITH DIFFERENTIAL;
A differential back up reduces the back up time (since only the changes are backed up).



No comments:

Post a Comment