On Fri, Jul 6, 2012 at 6:07 PM, Vincent Teachout <[email protected]> wrote: > Do any of you SQL gurus know if there is a way to backup a SQL Server > database, except for 1 specified file? I'm not seeming to find any > native solution so far. Thanks! ---------------------
I don't think that you can do this. Despite what Ted said it doesn't give you an option to list. If you had set this table into its own file group yes. http://msdn.microsoft.com/en-us/library/ms186865.aspx You can select * into [OtherTable].database.dbo.newTableName for everything you need to move to the movable backup you would make next or just detach it. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajidmykfbpmeepfjvahhxpg3cctybqslgko1ak6q_7+demm...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
