April 18, 2008
BACKUP DATABASE Test TO DISK=’\\IP\D$\Test.bak’ Will throw error “Cannot open backup device” if the SQL service account of the native server is not having permission to access the network share
BACKUP LOG … Statement will throw error if the recovery mode of the database is set to Simple…
Other than FULL Backup there is no other choice to backup MASTER DB
If unique index is defined on not null column(s), then it is essentially the same as the Primary Key and can be treated as an alternate key meaning it can also serve the purpose of identifying a record uniquely in the table.
Rebuildm.exe has been discontinued in SQL Server 2005. Instead you must run setup from the command prompt and add the REBUILDDATABASE parameter.
No comments yet.
RSS feed for comments on this post.
TrackBack URI