Sql Backup And FTP

Welcome Guest Search | Active Topics | Log In | Register
New Topic Post Reply
mdf and ndf file backup Options · View
ruslan
#1 Posted : Friday, April 08, 2011 8:39:30 AM Quote
Rank: Administration

Groups: Administrators

Joined: 8/10/2009
Posts: 368
We have a SQL 2003 Server and the database files are the mdf and also the newer style ndf files. I just wanted to check to make sure the program will correctly backup the ndf file as well as the MDF file and we don't need to do naything else to cater fort these ndf files ?
ruslan
#2 Posted : Friday, April 08, 2011 8:45:58 AM Quote
Rank: Administration

Groups: Administrators

Joined: 8/10/2009
Posts: 368
SQLBackupAndFTP executes BACKUP DATABASE command that disregards your physical file structure. As such, it does not matter how you have organized your data files (mdf and ndf). However it is absolutely necessary that you don't just blindly trust SQLBackupAndFTP, but verify the quality of backup yourself by restoring it at least once to make sure you can rely on future backups.
Quick Reply Show Quick Reply
New Topic Post Reply
Forum Jump  
You can post new topics in this forum.
You can reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You can create polls in this forum.
You can vote in polls in this forum.