Database creation and Backup

--Create a database

Create DATABASE MyDB

On primary

(

Name=mydbdata,

Filename= ' E:\mydb_data.mdf ',

SIZE=5MB,

MAXSIZE=6MB,

Filegrowth=1mb

)

Log on

(

Name=mydblog,

Filename= ' E:\mydb_log.ndf ',

SIZE=2MB,

MAXSIZE=5MB,

filegrowth=1%

)

--Delete Database

Use master

Go

if exists (SELECT * from sysdatabases where name= ' mydb ')

Drop Database MyDB

Go

--Add secondary database

ALTER DATABASE MyDB

Add log file

(

NAME=MYDALOG2,

Filename= ' E:\mydb_log2.ndf ',

SIZE=1MB,

MAXSIZE=5MB,

filegrowth=1%

)

--Delete Secondary database

ALTER DATABASE MyDB

Remove File Mydalog2

--Modify the database name

ALTER DATABASE MyDB

Modify Name=youdb

--Backup Database--name= ' Mydbbackup ' is a remark to write casually

Backup Database mydb to disk= ' E:\mydbbackup.bak ' with format, name= ' Mydbbackup '

--Recover Database

Use master

GO

Restore Database MyDB from disk= ' E:\mydbbackup.bak '

GO

Database creation and Backup