use slktestdb
select * from sys.filegroups
alter database slktestdb
add file fg1

alter database slktestdb
modify filegroup fg1 readonly

alter database slktestdb
add file (
name = 'file1',
filename = 'C:program filesMicrosoft SQL ServerMSSQL.1MSSQLDATAile1.ndf',
size = 5mb,
filegrowth = 1mb,
maxsize = 10mb
)
to filegroup fg1

alter database slktestdb
modify filegroup fg1 readonly
select * from sys.filegroups

alter database slktestdb
modify filegroup [primary] readonly

alter database slktestdb
modify filegroup fg1 readwrite
select * from sys.filegroups

sp_helpdb slktestdb

alter database slktestdb
modify file (
name = 'file1',
maxsize=20mb
)

use slktestdb
select * from sys.filegroups
alter database slktestdb
add file fg1

alter database slktestdb
modify filegroup fg1 readonly

alter database slktestdb
add file (
name = 'file1',
filename = 'C:program filesMicrosoft SQL ServerMSSQL.1MSSQLDATAile1.ndf',
size = 5mb,
filegrowth = 1mb,
maxsize = 10mb
)
to filegroup fg1

alter database slktestdb
modify filegroup fg1 readonly
select * from sys.filegroups

alter database slktestdb
modify filegroup [primary] readonly

alter database slktestdb
modify filegroup fg1 readwrite
select * from sys.filegroups

sp_helpdb slktestdb

alter database slktestdb
modify file (
name = 'file1',
maxsize=20mb
)

use slktestdb
select * from sys.filegroups
alter database slktestdb
add file fg1

alter database slktestdb
modify filegroup fg1 readonly

alter database slktestdb
add file (
name = 'file1',
filename = 'C:program filesMicrosoft SQL ServerMSSQL.1MSSQLDATAile1.ndf',
size = 5mb,
filegrowth = 1mb,
maxsize = 10mb
)
to filegroup fg1

alter database slktestdb
modify filegroup fg1 readonly
select * from sys.filegroups

alter database slktestdb
modify filegroup [primary] readonly

alter database slktestdb
modify filegroup fg1 readwrite
select * from sys.filegroups

sp_helpdb slktestdb

alter database slktestdb
modify file (
name = 'file1',
maxsize=20mb
)

dbcc checkdb
dbcc checkalloc
dbcc help (checkalloc)

alter database slktestdb set emergency
alter database slktestdb set online
alter database slktestdb set read_only

alter database slktestdb set read_write
alter database slktestdb set single_user
use testdb
use slktestdb
alter database slktestdb set multi_user
use testdb
alter database slktestdb set restricted_user

use slktestdb
create table test (id int)
insert into test values (1)
select * from test
begin tran t1
insert into test values(2)
commit tran t1
rollback tran t1

begin tran t1
insert into test values(3)

dbcc opentran()
sp_who2
commit tran t1
dbcc inputbuffer(56)

sp_helpdb slktestdb

alter database slktestdb
modify file
(
name = 'slktestdb1',
size = 3mb
)
create database example
sp_helpdb example
sp_helptext 'sp_attach_db'
sp_attach_db
drop database example

sp_helpdb slktestdb
sp_database

create database vinod
sp_helpdb tempdb

dbcc checkdb
dbcc opentran()
sp_helpdb
dbcc sqlperf (logspace)

create proc temp as dbcc sqlperf (logspace)

set nocount on
create table #temp1 (dbname nvarchar(max), logsize float, logspaceused float, status int)
insert into #temp1 exec temp
select * from #temp1

sp_helpdb 'slktestdb'

select *from sys.databases
select *from sys.sysdatabases
select name,recovery_model_desc from sys.databases

alter database slktestdb
set recovery bulk_logged

alter database slktestdb
set recovery full

sp_dboption 'slktestdb'
sp_dboption 'slktestdb', 'trunc. log on chkpt.','false'
  select * from sys.sysprocesses where dbid = db_id('slktestdb')
use master
restore database slktestdb with recovery

create database slkbackupdb1
on primary
(
name='slkbackupdb1',
filename = 'c:Backup1.mdf',
size = 10mb,
maxsize = 20mb
)

log on
(
name='slkbackupdb1_log',
filename = 'c:Backup1_log.ldf',
size = 10mb,
filegrowth = 20%,
maxsize = 20mb
)
sp_addumpdevice 'disk','bak_device_1','C:sqllabkpak_device_1.bak'

backup database slkbackupdb1 to disk = 'praclab2sssvinod.bak'

backup database slktestdb to bak_device_1
backup log slktestdb to bak_device_1

backup database slkbackupdb1 to disk='C:sqllabkpak_diff.bak' with differential

sp_addumpdevice 'disk','test1','C:sqllabkp est1.bak'

backup database slkbackupdb1 to test

restore filelistonly from test

restore headeronly from test

backup database slktestdb to test

restore headeronly from test

restore filelistonly from test

backup database master to test with init  --overwrite the backup content(init)

backup log slktestdb to disk = 'c:sqllabkp ailLOG.bak' with norecovery,no_truncate  --norecovery=to tell sql server is restoring

alter database slktestdb
modify filegroup fg1 readonly

select * from sys.filegroups

backup database slktestdb read_write_filegroups to disk = 'c:sqllabkppartial.bak'

sp_addumpdevice 'disk','bak1','C:sqllabkpak1.bak'
sp_addumpdevice 'disk','bak1_mirror','C:sqllabkpak1_mirror.bak'

backup database slktestdb to bak1
mirror to bak1_mirror with format

select @@servername,@@version

--checksum of a databse
backup database slktestdb to disk = 'C:sqllabkpchk.bak' with checksum

restore verifyonly from disk = 'C:sqllabkpchk.bak'