Very Computer

Does anyone know whether the data stored for an image data type is stored in the .mdf data file or .bak backup file of the database. For example if I was to lose the data but had a backup then will the database be fully restored along with all 'image' data.

Thanks
Matthew

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Matthew:

SQL stores data in the database files, typically name .mdf and/or .ndf.
When you backup your database, all data is backed up and can be restored.

To test this, use the pubs database.  Create a small table with text data
and add a couple of rows.
Backup the pubs database, drop the table, then restore the pubs database.  

Hope this helps

Ed Harper
Microsoft SQL Support

========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
========================================================