Shulou(Shulou.com)06/01 Report--

-- 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 the 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

-- backing up the database-- name='mydbbackup' is a comment to write freely.

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

-- restore the database

USE master

GO

Restore database mydb from disk='E:\ mydbbackup.bak'

GO

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.