0

I have a 50GB SQL Server 2008R2 database backup.

I'd like to restore only the "tables" and not the filestream data (the blobs saved as filestream).

This is because I fon't have 100GB free (50 needed to copy the file on the server, 50 to restore the db).

Is there a switch for the restore command to avoid restoring filestream blobs?

DanBig
  • 11,423
  • 1
  • 29
  • 53
user193655
  • 253
  • 1
  • 5
  • 18

1 Answers1

1

No, you cannot restore specific structures from a SQL Server backup; it's all or nothing. Your best bet is to try scripting out the data using a third party tool or using the generate scripts option SQL Server Management Studio.

Jason Cumberland
  • 1,579
  • 10
  • 13