DATABASE Administration

ERPWEB is e-Business Operating System

DATABASE MANAGEMENT

CATALOG_NAME	SCHEMA_OWNER	Action
master	dbo	Detach
tempdb	dbo	Detach
model	dbo	Detach
msdb	dbo	Detach
pubs	dbo	Detach
Northwind	dbo	Detach
erpweb	dbo	Detach
stores	dbo	Detach
erptrial	dbo	Detach
eveda	dbo	Detach
eblank	dbo	Detach
erun	dbo	Detach
CREATE DATABASE databasename
EXECUTE sp_attach_db @dbname = databasename, @filename1 = 'c:\mssql7\data\filename.mdf', @filename2 = 'c:\mssql7\data\filename_log.ldf'

Note:  Creating a logical backup device needs to be done only once.

EXECUTE sp_addumpdevice 'disk', devicename,'c:\MSSQL7\BACKUP\devicename.dat'
BACKUP DATABASE databasename TO devicename
RESTORE DATABASE databasename FROM devicename

ERPWEB provides complete e-Business Infrastructure at lowest costs

This document last updated on

---

© Copyright 2001 . All rights reserved. ERPWEB.COM is registered trademark of ASIC Infotech Pvt. Ltd. Home | Contact