Create a copy of a static database.
CREATE DATABASE VCDB_COPY AS COPY OF VCDB
In a way, this is very much creating and restoring from a full backup.
Subscribe to:
Post Comments (Atom)
MSSQL: Getting more detail information for failed jobs.
Often when a job failed, it provides trivial information for diagnostic. In order to expand the detail of the failed job, it can be done th...
-
Often when a job failed, it provides trivial information for diagnostic. In order to expand the detail of the failed job, it can be done th... -
Trying to map FKs between Dimension and Fact Tables and Database Diagram crashed with error message "Index was outside the bounds of th... -
Trying to query the catalog.executable_statistics view and the object is missing. The reason is, there isn't SSIS project or packages be...
No comments:
Post a Comment