For validating mdf files


You can detach the data and log files for a database but you need to ensure that these log files either have been detached from a server, or copied after shutting down the server.This ensures that all transactions for that database are them to another server and put them on that server in a process that is much faster than a restore, although not necessarily as safe, since you have to copy or move your files.SQL Server native backups, of course, always consider this!Data Domain from EMC, a combination of software and a SAN, certainly offer transactional support, as do other vendors, but check your SAN documentation.You can do this through the GUI, or by running this T-SQL: The different numbers represent different versions of SQL Server; , 1 and 2008R2 and 1. Microsoft only allows you to jump forward a maximum of two versions.


If you don’t see them, then I strongly suggest you test a restore of a database before you assume that the SAN backups alone will support your backup requirements.The main issues you might encounter are in the form of errors arising from insufficient space for the restored database, in the new location, or because you forgot to supply a new name and attempted to restore over the top of your existing database.When restoring the database on a different instance of SQL Server you might hit problems with ‘Orphaned Users’, if the database user is mapped to a SID that is not present in the new server instance. The only time that you can do this is when the DB was shut down cleanly before the log file was lost. You need the transaction log file as well as the data files because SQL Server references the log file when attaching the DB, it’s the crash recovery process..If you are relying on SAN backup, you’re still going to have to check for database consistency, either by running DBCC checks on the live database, or by restoring a database from a SAN backup and running the checks on that.

Otherwise, you may just be backing up a corrupted database.

While attaching a data file without the log file may be possible in some circumstances, it is not a recommended approach and is only for cases when the log file has been damaged or lost due to hardware problems and there are no backups available.


Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>