|
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).
|
Tuesday, 9 June 2020
create a data base with query
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment