July 1, 2008 at 6:02 pm
We have a customer that is getting an extra file in their database
backup. this is not one of our nightly jobs. Can you please ID
where this job is run from and answer his question below.
------------------------------------------------------------------
Last night db backup contains extra ndf file that we are not
> expecting. Why is this new ndf file in the backup?
>
> InsLogicQuest_Data L:\SQLDATA\InsLogicQuest_Data.MDF D PRIMARY
> 2024603648 35184372080640 InsLogicQuest_1_Data
> J:\SQLData\InsLogicQuest_Data_J D PRIMARY
> 1879375872 35184372080640
> InsLogicQuest_DataEm03 U:\SQLData\InsLogicQuest_DataEm03.ndf
> D PRIMARY 2097152 35184372080640
> InsLogicQuest_Log I:\SQLLog\InsLogicQuest_Log.LDF L NULL
> 277086208 35184372080640
There is a Full backup job scheduled for everynight..which is working fine, so is this issue like a FTP being run by someone. If yes, how and where can I check for the error and resolve it..
Thanks in Advance.
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
July 1, 2008 at 10:46 pm
talentguy123 (7/1/2008)
We have a customer that is getting an extra file in their databasebackup. this is not one of our nightly jobs. Can you please ID
where this job is run from and answer his question below.
------------------------------------------------------------------
Last night db backup contains extra ndf file that we are not
> expecting. Why is this new ndf file in the backup?
>
> InsLogicQuest_Data L:\SQLDATA\InsLogicQuest_Data.MDF D PRIMARY
> 2024603648 35184372080640 InsLogicQuest_1_Data
> J:\SQLData\InsLogicQuest_Data_J D PRIMARY
> 1879375872 35184372080640
> InsLogicQuest_DataEm03 U:\SQLData\InsLogicQuest_DataEm03.ndf
> D PRIMARY 2097152 35184372080640
> InsLogicQuest_Log I:\SQLLog\InsLogicQuest_Log.LDF L NULL
> 277086208 35184372080640
There is a Full backup job scheduled for everynight..which is working fine, so is this issue like a FTP being run by someone. If yes, how and where can I check for the error and resolve it..
Thanks in Advance.
Looks like someone added a new file to the primary file group. I would check the properties of this database to verify that the database does indeed have this new file. If so, then you need to follow up with your customer and find out why they added this new file.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 2, 2008 at 4:41 pm
Ok, I have cofirmed that there is a .ndf file in the DB's primary filegroup. I have conveyed the msg across to the concerned authorities and that they should ask for the reason it was done by the client. Now, that being said what is the solution to it, for that even it got backed up but the Full backup job. Can I manually delete it? if so from where? the backup location or from properties by right clicking the DB?..
Thanks in Advance
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
July 3, 2008 at 2:02 pm
You can use the following script to remove the extra data file:
USE InsLogicQuest
GO
DBCC SHRINKFILE ('InsLogicQuest_DataEm03',EMPTYFILE)
GO
ALTER DATABASE InsLogicQuest
REMOVE FILE InsLogicQuest_DataEm03
GO
This will move all of the data to the InsLogicQuest_Data data file and drop the InsLogicQuest_DataEm03 data file provided there is enough free space in InsLogicQuest_Data to hold the data from InsLogicQuest_DataEm03.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply