Friday, January 20, 2006
Thursday, January 19, 2006
Manipulation of user accounts in Windows with dotNet.
Backup and Restore commands can only be executed from within the master database; this is accomplished by issuing the USE master command. The example below backs up the USRDB database to disk.
BACKUP DATABASE USRDB TO DISK = 'C:\Backup\Renee\DatabaseBackup\2005.07.20.1200.USRDB.Bak'
DROP DATABASE USRDB
RESTORE DATABASE USRDB FROM DISK = 'C:\Backup\Renee\DatabaseBackup\2005.07.20.1200.USRDB.Bak'