Welcome! » Log In » Create A New Profile

Using TDP to backup NDF files

Posted by Bill Boyer 
Bill Boyer
Using TDP to backup NDF files
December 13, 2017 07:59AM
Is there a way to backup NDF files as part of the database backup? I have a
customer with a database with an NDF file the use for 'archiving'. That
doesn't get included as part of the TDPSQLC BACKUP * FULL command. How can I
get that included in the SQL backup of the server? Or do I need to use the
BAClient for that?



TIA,



Bill

"Enjoy life. It has an expiration date." - ??
This message was imported via the External PhorumMail Module
Harris, Steven
Re: Using TDP to backup NDF files
December 13, 2017 02:59PM
Bill

There is an option in TDP to back up a file group. I've never understood what it is for. Looking online for information about NDF files, that same term, "file group", popped up. So, I'd start there are see if that fits your use case.

Cheers

Steve

Steven Harris
TSM Admin/Consultant
Canberra, Australia



-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Bill Boyer
Sent: Thursday, 14 December 2017 2:24 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Using TDP to backup NDF files

Is there a way to backup NDF files as part of the database backup? I have a customer with a database with an NDF file the use for 'archiving'. That doesn't get included as part of the TDPSQLC BACKUP * FULL command. How can I get that included in the SQL backup of the server? Or do I need to use the BAClient for that?



TIA,



Bill

"Enjoy life. It has an expiration date." - ??

This message and any attachment is confidential and may be privileged or otherwise protected from disclosure. You should immediately delete the message if you are not the intended recipient. If you have received this email by mistake please delete it from your system; you should not copy the message or disclose its content to anyone.

This electronic communication may contain general financial product advice but should not be relied upon or construed as a recommendation of any financial product. The information has been prepared without taking into account your objectives, financial situation or needs. You should consider the Product Disclosure Statement relating to the financial product and consult your financial adviser before making a decision about whether to acquire, hold or dispose of a financial product.

For further details on the financial product please go to http://www.bt.com.au

Past performance is not a reliable indicator of future performance.
This message was imported via the External PhorumMail Module
Sorry, only registered users may post in this forum.

Click here to login