Kamis, 29 Juli 2010

Database internal file versions– How to determine if the database was upgraded or created from scratch

In some cases it it interesting to know whether a database was directly created on the current version of the running SQL Server instance or if the database was upgraded during an upgrade of the instance or by attaching a database from an older version to a newer version of SQL Server. The information is stored in the datafile headers. To reveal it you will have to use the DBCC command and

Tidak ada komentar:

Posting Komentar