SQL Server Database Administrator

View :: Any relation which is not part of logical model,but is made visible to a user as a virtual relation, is called a view. --CREATE VIEW [ schema_name . ] view_name [ (column [ ,...n ] ) ] [ WITH <view_attribute> [ ,...n ] ] AS select_statement [ ; ] [ WITH CHECK OPTION ] < view_attribute > ::= { [ ENCRYPTION ] [ SCHEMABINDING ] [ VIEW_METADATA ] } ----------------------------------------------------------------------------------------- ENCRYPTION : The definition of an encrypted view is not visible to anyone, including a member of the sysadmin fixed server role.cannot decrypt the definition. SCHEMABINDING : cannot drop any tables, views, or functions referenced by the view without first dropping the view. VIEW_METADATA : ----------------- Example:CREATE VIEW v_CustomerAddress AS SELECT a . CustomerID , a . CustomerName , c . AddressLine1 , c . AddressLine2 , c . AddressLine3 , c . City , d . StateProvince , c . P...

RESTORE FILELISTONLY retrieves the list of database and log files in the backup. RESTORE HEADERONLY returns header information about all backup sets on the supplied backup device. Although this command returns a wealth of information, typically you will only examine a small portion of it. For instance, it might be beneficial to know a backed up database’s collation, type of backup, first and last Log Sequence Numbers and database compatibility level. RESTORE FILELISTONLY FROM DISK = 'e:\telefullbkp' RESTORE HEADERONLY FROM DISK = 'e:\telefullbkp' RESTORE FILELISTONLY FROM DISK = 'D:\backup\Banking_20120929192001.trn' RESTORE HEADERONLY FROM DISK = 'D:\backup\Banking_20120929192001.trn' ********************************************************************************************* /* restore the full backup first with NO RECOVERY */ RESTORE DATABASE pubs FROM DISK = 'e:\pubs.bak' WITH...