SHRUTI PANDEY

• Nov 15th, 2006

 

SQL SERVER 2000 IS A RICH FROM LOTS OF FACILITIES LIKE CREATE, INSERT, SELECT, MODIFY, GRANT, REVOKE, CHECK CONSTANTS,M DEFAULT, UNIQUE, NULL/NOT NULL, CONDITIONS, IMPORT/EXPORT ETC.WE CAN EASLY PROTECT SQL SERVER DATABASE THROUGH THE COMANDS OF SQL SERVER LIKE REVOKE AND GRANT OPTIONS.GRANT COMMAND GIVE PERMISSION  TO PUBLIC OR LIMITED USERS AND REVOKE COMMAND DENAY THE PERMISSION TO PUBLIC.

pratap das

• Nov 23rd, 2006

 

this is also worhs mentioning database backup & recovery

psingla

 Profile Answers by psingla Questions by psingla

• Mar 8th, 2010

 

Solution1:
Create a replica of a database on a different machine.
Update the replica using log shipping functionality of sqlserver.

Advantage:
Less space is used

Disadvantage:
Complex

Solution2:
Take the complete backups of the databases.

Advantage:
Simple

Disadvantage:
More space is used