Database Reference
In-Depth Information
8.
For both restore database and restore log, the results will be as follows:
Processed 168 pages for database 'PieceMealDB', file 'PMDB_
PRIMARY' on file 1.
Processed 1 pages for database 'PieceMealDB', file 'PMDB_log' on
file 1.
RESTORE DATABASE ... FILE=<name> successfully processed 169 pages
in 0.206 seconds (6.409 MB/sec).
Processed 0 pages for database 'PieceMealDB', file 'PMDB_PRIMARY'
on file 1.
Processed 6 pages for database 'PieceMealDB', file 'PMDB_log' on
file 1.
RESTORE LOG successfully processed 6 pages in 0.076 seconds (0.533
MB/sec).
9. Let us verify the file status for the
PieceMealDB
database by querying
system catalog:
use PieceMealDB
go
select name,state_desc,physical_name from sys.master_files where
name like '%PMDB%'
GO
It is also possible to obtain similar information using
DATABASEPROPERTYEX system function. The statement will be: SELECT
DATABASEPROPERTYEX ('PieceMealDB','STATUS');
Search WWH ::
Custom Search