Secondary Data File Extension Changes To Mdf After Restore

Apr 18, 2007

i have sql server 2000 db with two data file... primary data file has extension mdf and secondary file has extension ndf (as per microsoft recommendation)..



when i try to backup the db and restore thru the enterprise manager .. in the restore -> options window ... i see both the files has the same extension mdf.. and when the restore completed, the new database still has extension mdf for both the file..



why this behaviour?



* i even try to create a new test db with two files, still its the same behaviour.

View 10 Replies


ADVERTISEMENT

Add To SSRS Data Extension With Config File

Apr 18, 2007

Hello,



I try to add an data extension who take the information to connect to the database in a config file. But It's could not retreive the values corresponding to the key.

I'm using the class ConfigurationManager from the namespace System.Configuration.



ConfigurationManager.AppSettings["QueryModel"]





Without the config file, the extension is working well.... I got the impression that reporting service and Visual Studio BI don't find the config file.



If someone can help me or have some advices. I will be pleased



View 1 Replies View Related

How To Remove Secondary Data File????

Jan 16, 2003

I have a SQL Server 2000 database with a primary data file (MDF) and a secondary data file (NDF). I would like to remove the secondary file and only have the MDF. Is this possible?

Thanks, Dave

View 3 Replies View Related

Can I Move To A Secondary Data File

Jun 22, 2007

I have a database that has been running well for a few years.
It has a single data file.
It has now become very large and is creaking and running slow sometimes.
Is it possible to now create a secondary data file or do i have other options?
Many Thanks

View 4 Replies View Related

SQL Tools :: Adding Secondary Data File In AlwaysOn?

Jul 27, 2015

how to add the Secondary Data file to the Database that is a part of the Always on Availability on SQL Server 2012.

View 3 Replies View Related

DB Engine :: How To Change Location Of Secondary Data File

Nov 9, 2015

I added a secondary data file to TEMPdb yesterday and gave it a wrong location by mistake. If I try to change the location, then I am getting an error now. I think that is because TEMPdb is in use and that is why I cant change it's secondary file's location. Do I need to take TempDB offline and then change the secondary file's location??

View 3 Replies View Related

Reporting Services :: Change File Extension Of CSV Data Driven Subscription?

Jun 16, 2015

Using SSRS 2008R2 is it possible to change the file extension of a CSV data driven subscription?  I'm outputting a text file with a .csv extension, but users have access to these files and I don;t want them opened with Excel and then saved back in an incorrect format. 

These are the options I have from the report "manage" option.  

View 2 Replies View Related

DB Engine :: DB Autogrowth Turned On In Secondary Data File Still 0% Internal Free Space

Oct 30, 2015

Today we received an issue on an application database on internal free space on the DB is 0% that was designed with as below

name    fileid    filename    filegroup    size    maxsize    growth    usage
XX    1    I:DataMSSQL.1MSSQLDataNew XX.mdf    PRIMARY    68140032 KB    Unlimited    0 KB    data only
XX_log    2    I:DataMSSQL.1MSSQLDataNew XX_log.LDF    NULL    1050112 KB    2147483648 KB    102400 KB    log only
XX_2    3    I:DataMSSQL.1MSSQLDataNew XX_2.ndf    PRIMARY    15458304 KB    Unlimited    0 KB    data only
XX_3    4    I:DataMSSQL.1MSSQLDataNew XX_3.ndf    PRIMARY    13186048 KB    Unlimited    0 KB    data only
XX_4    5    I:DataMSSQL.1MSSQLDataNew XX_4.ndf    PRIMARY    19570688 KB    Unlimited    204800 KB    data only
XX_5    6    I:DataMSSQL.1MSSQLDataNew XX_5.ndf    PRIMARY    19591168 KB    Unlimited    204800 KB    data only

2 of the secondary data files had its autogrowth enabled to unrestricted with 200MB and 3 of the data files including primary had its Autogowth turned OFF. Application use is complaining that there is no internal freespace on the DB.

What fails to understand us is that when the Auto growth was already TURNED OFF on 3 data files ( 1 primary and 2 secondary ) still why was the application trying to increase the space on the .mdf and .ndf files; as well when the Autogrowth is TURNED ON on 2 of the secondary data files, why was the DB not able to expand these file groups when the autogrowth is already turned off on 3 of its  other files.

What more data i need to ensure i submit an analysis to this.

View 5 Replies View Related

Log Shipping Will Not Restore Tran Logs On Secondary Server

Nov 6, 2006

We're planning to implement log shipping on our databases, and I have been toiling with it all weekend trying to get it to work on some test databases. The result is the same whether I do it via the wizard or manually via T-SQL.

I am using 3 servers, all SQL Server 2005 Standard SP1. All 3 SQL Servers are configured identically.

When I setup log shipping, it initializes with no problems. When it processes the first tran log file, it restores it with no problem. Every successive log file thereafter is not restored. No errors are generated. The only outright indication of a problem is that the monitor server shows that there has not been a recent restore.

The backup and copy both suceed. The restore claims to suceed. If I review the job history for each step, it says that it skipped the log file and then reports that it did not fina any log files to restore.

Message
2006-11-06 05:00:01.92 Skipped log backup file. Secondary DB: 'MyDemo', File: 'D:MSSQLBackupMyDemoMyDemo_20061106115619.trn'

Message
2006-11-06 05:00:01.95 Could not find a log backup file that could be applied to secondary database 'MyDemo'.
2006-11-06 05:00:01.96 The restore operation was successful. Secondary Database: 'MyDemo', Number of log backup files restored: 0



Any ideas or suggestions?

View 3 Replies View Related

Recovery :: Logship Database Failed To Restore On Secondary Server Error

Aug 4, 2015

I'm working on SQL 2012 Box, which is having Logshipping failed on secondary database, the secondary database was in stand by mode right now but no more restore operation performed on this database since 2 weeks! We checked in the SQL error log and found the error code 14421, severity 16, stat: 1

How to reset the logship back to normally, do I need to disable the jobs before proceed any operation!

View 7 Replies View Related

DB Engine :: Extension FILE Among Backup File

May 8, 2015

I checked quickly one network  and I ran into the folders; I found out the folder MSSQL backup, nothing strange so far. Within that folder, anyway, I found out several backup and one very huge file (datawarehouse) with extension FILE. I am wondering what can be? I got datawarehouse mdf of course and datawarehouse log but what is that huge file (1 TB)?

View 6 Replies View Related

File Extension

Sep 27, 2006

I was told by my website provider that they do not support the .mdf extension and only support the mdb extension. What am I not getting here? I am using SQL Server Express 2005. Is .mdf a subset of .mdb?

View 1 Replies View Related

RESTORE DATABASE FROM JUST DATA FILE

Jun 4, 1999

DOES ANYONE KNOW HOW I CAN RESTORE A SQL7 DATABASE WITH JUST THE DATA FILE?
THERE IS NO GOOD BACKUP OF THE DATABASE AND THE LOG FILE IS MISSING. THE CLIENT THOUGHT THEY WHERE BACKING UP THE DATABASE BACKUP FILE TO TAPE, BUT THEY WHERE NOT. THE BACKUP FILE WAS BEING OVERWRITTEN EVERY NIGHT. THE LAST NIGHTS BACKUP DID NOT GET TO FINISH TO COMPLETION.
PLEASE, ANY INPUT WOULD BE APPRECIATED.
THANKS,
TIM

View 1 Replies View Related

READ A FILE WITH EXTENSION Dat

Aug 16, 1999

Hi,

I need to read a binary file with extention *.dat like this:
tat.dat and import it in ms sql server 7.0.

Thanks for any help

Dr Bangaly Diané

View 2 Replies View Related

File Extension For Sqlserver2000

Oct 25, 2006

Hi,

If access database has an extension of .mdb then what is sqlserver2000 file extension?

View 1 Replies View Related

Spool File Without An Extension Name

Feb 2, 2008

Hello there!

I am in need of urgent help. i do believe that when you used the command SPOOL filename without specifying an extension name, it automatically puts an .lst extension name. Can you help me identify if there is any way i can generate a file without an extension name? I am in need of help right now. I hope someone will answer my post as soon as possible. I really really appreciate it!

Thanks,
Jen

View 1 Replies View Related

File Name Or Extension Is Too Long

Jul 20, 2005

Hi All,I am receiving the following message when I run Dts package which iscreating a cube.Error Source : Microsoft Data transmission Services (DTS)PackageError Description: File name or extension is too longAny help will be appreciated!Thanks in advance,Mohammed SarwarOcp dba oracle 9i,8i,8.0*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!

View 1 Replies View Related

Which Kind Of File With Extension .pem ?please Help Me

Jan 4, 2006

In document for  encryption in SQLServer with application XP_Crypt, i see file with extension .pem when using private key or public key. How to create file .pem. Please explain me private key or public key.

View 1 Replies View Related

Restore / Recover SQL Database From Data File

Feb 24, 2002

Our SQL database log file got physically deleted. Now the database is in suspect mode. Is it possible to recover / restore the database just with the data file.

View 3 Replies View Related

How To Restore Data From A Device File On The Harddisk

Aug 27, 1999

i had to fromat the harddisk for some reason , but took a backup of the data device file . is it possible to recover tha data from them .

View 1 Replies View Related

Alter Database File Extension

May 14, 2008



Hi,

I'm trying to change the file extension of one of the database files of a big database that contains 10 years of EPOS data.
When this file was created, at the beginning of 2008, with the following script:

USE [Live]


ALTER DATABASE [Live] ADD FILE (NAME = 'Live_2008',

FILENAME = €˜E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataLive_2008') TO FILEGROUP [2008]
the .ndf file extension was not added to the filename. So the file now has a file type of "File", instead of "SQL Server Secondary Data File"
I tried, in a test environment, to bring the database offline, change the filename to "Live_2008.ndf" and bring the database back online, but it gives me an error message saying that "cannot open the Live_2008 file", i'm guessing because it's looking for "Live_2008" and it finds "Live_2008.ndf" instead.
This file is quite big (5Gb) and I cannot afford to risk to lose any data.
The situation is complicated even further by the fact that it seems that a partition for 2008 does not exist.
How can I find out what data this file contains?
Is it going to be an issue if I leave the file like that?
Thanks

View 3 Replies View Related

ForEach File Enumerator Extension Bug?

Jul 5, 2006

I set up a basic ForEach enumerator loop and specified files of type *.sql.

In the directory, I had some files I needed to keep but didn't want the package to touch, so I changed the extension to *.sqlo. Much to my dismay, the ForEach loop picked up those files. (Though it did skip the *.xml and *.bat and a few other types...)

Sounds like a bug to me.

View 3 Replies View Related

SQL 2012 :: How To Transfer Login To Secondary Server And Assign Same Permission To Secondary DB

Jan 24, 2015

i have created a new login in primary server and provided dbowner permission to primary db.how do i transfer this login to secondary server and assign the same permission to secondary db ?

View 2 Replies View Related

Trying To Eliminate Secondary Log File

Mar 14, 2003

I'm trying to run a set of DBCC commands to empty and then delete a secondary log file; however, no matter how large I make the primary log file it won't empty the secondary file. Any suggestions?

DBCC SHRINKDATABASE (VE, 10)
GO
alter database VE modify file (name= VE_log,size = 1200)
GO
dbcc shrinkfile (VE_log2,EMPTYFILE)
GO
Cannot shrink log file 3 (VE_Log2) because all logical log files are in use.
DbId FileId CurrentSize MinimumSize UsedPages EstimatedPages
------ ------ ----------- ----------- ----------- --------------
17 3 86848 128 86848 128

--alter database VE remove file VE_log2
--GO

View 1 Replies View Related

Removing Secondary .ndf File

Aug 16, 2002

I've inherited a database from a SQL7 system, and converted it to SQL2000. It has a secondary data file (.ndf) and a secondary log file. Because the server configurations are different it's no longer necessary to have the secondary files. How to I merge the secondary file data into the primary files and then delete the secondary files?

Thanks,

Al

View 1 Replies View Related

Restore To New Db Restores Less Data Than What Is In The Source Backup File

Jan 25, 2006

I am trying to create sql code that restores a backup of a master database to a new database on the same server. It “seems” to run correctly as no errors are produced. However, the most recent updates to the master database are not present in the new databases. All databases are using the Full recovery model. What is really strange is that if I do (what I think is) the same function in Enterprise Administrator, the restore works fine! For both methods I used the same backup file!



Any and all help is sincerely appreciated.


The master databases from which the backups are made start with “MODTRNMaster”

The databases which are created from the restores start with “M1_” and “M2_”. (We call them training room databases.)



My script for backing up the master databases:



-- Backup the master training database

backup database MODTRNMaster
to disk = 'f:kupMODTRNMaster.bak'

backup database MODTRNMaster_IMG
to disk = 'f:kupMODTRNMaster_IMG.bak'

backup database MODTRNMaster_MNC
to disk = 'f:kupMODTRNMaster_MNC.bak'

backup database MODTRNMaster_VM
to disk = 'f:kupMODTRNMaster_VM.bak'

go


This is the restore script for restoring the first training room databases. I’m hoping that there is just something simple that I’m overlooking in these restore statements! J



-- Restore the backup of the master training database into the

-- training room #1 database.

use master
go

drop database M1_MSLH
go


restore database M1_MSLH
from disk = 'f:kupMODTRNMaster.bak'
with move 'DEV5_Data' to 'f:mssqldataM1_MLSH.mdf',
move 'MM' to 'f:mssqldataM1_MLSH_1.mdf',
move 'AMB' to 'f:mssqldataM1_MLSH_2.mdf',
move 'DM' to 'f:mssqldataM1_MLSH_3.mdf',
move 'IMM' to 'f:mssqldataM1_MLSH_4.mdf',
move 'ED' to 'f:mssqldataM1_MLSH_5.mdf',
move 'DEV5_Log' to 'f:mssqllogM1_MLSH_log.ldf',
recovery

go



Thanks in advance

:eek:

:eek:

View 5 Replies View Related

Data File Growth Afer Restore On 2005

Oct 15, 2007

Hi at all,
first post....first help :P .
I hope to help another one (basing on my knowledge) in the next future :)

I'm a beginner dbadmin and I'm looking for help regarding a strange fact relative SQL Server 2005 :)

I migrated a medium(3,5GB) database from sql server 2000 to sql server 2005.
I made a backup in sql server 2000 (it has generated a 3,5GB BAK FILE) and I restored it in sql server 2005 on another server. (I didn't checked data file size).

I configured (with wizard) a maintenance plan on new sql server 2005 with these steps (in this order):
(tellme if the order of the steps is wrong :))

1) check db
2) rebuild index
3) reorganize indexes
4) update statistics (all table and all views)

I planned the maintenance plan on 3a.m. and I went home.

Next day I found that data file (MDF) on sql server 2005 was 22GB large!!
I made a shrink DB but there wasn't free space to erase. It seems there are
22GB of data.
(the data inside is the same of the sql 2000 server..same records same
table...identical, non change of data in the meanwhile)

How is it possible? What am I doing wrong?
I don't understand what can caused the growth of the file, the maintenance plan or the restore? (unfortunately....I didn't checked size after restore...I checked it only the next day).
May be the statistics? (there wasn'int update statistics job on old maintenance plan on sql server 2000)

Thanks in advance :)
Bob

View 20 Replies View Related

Custom Source Extension && File Permissions

Sep 26, 2007

I programmed a Source extension, that accesss a text file. In my code I have the following code to open a file:

protected override void reader(PipelineBuffer buffer)
{
TextReader reader = File.OpenText(_filename);

The komponnet works well. How do I grant permissions to access this text file? Because I got problems when I try to run my package using a task created in the SQL Server Agent.

View 3 Replies View Related

SQL Tools :: Differential Backup File Extension

Dec 8, 2008

I have just begun to try out differential backups. Almost every reference I found on the internet said to use a .dif file extension. Books Online "Back Up Database Task (Maintenance Plan) MS.SQLCC.v9/MS.SQLSVR.v9.en/uirfsql9/html/ed1ef012-fa14-4ba5-bafe-d1527ba065b3.htm only says :

Backup file extension Specify the extension to use for the backup files. The default is .bak.
                                                                                                                                   
Using .dif for the differential shows "Microsoft Office Excel Data Interchange Format" as the type when looking at the backup folder. URL... indicates that .dif has 11 different uses, including "Difference data file." In a couple of posts in this forum in April and May of this year David Dye said that the file extension for differential backups is .bak, the same as for the full backup.
 
If this is the case, this would cause a problem with our maintenance plan policy which is to retain the two most recent backup files on the server. If we do a full backup for the base on the weekend and differential backups the rest of the week, our full backup would have to be restored from out tape system before we could do a restore. Recoveries are pretty rare, but when we get that panicked phone call that someone accidently deleted all the records of a major client, time is of the essence in getting that point in time restore done.

View 6 Replies View Related

SQL 2012 :: Load Log File To Secondary DB

Mar 11, 2015

I am after T-SQL code which will simply load the next T-log backup file from a network share folder to a warm standby db on a secondary server.What is needed is a Third server (server x), to participate in log shipping (MULTIPLE TARGETS).

Primary SERVER (SERVER A)
Secondary SERVER (SERVER B) Log shipped to via GUI.
THIRD SERVER (SERVER X) which will contain the same log shipped db from server A.

This will simply restore the logs from a network share to keep the db up to date.

View 3 Replies View Related

Integration Services :: How To Open MAR File Extension In SSIS

Nov 30, 2015

I have a source file as filename.mar it is microsoft access report. When I am loading into my database the file name was something like filename.nov (its current month).

When I ran the package its shows error system cannot find the file filename.nov.

View 2 Replies View Related

Secondary File On Encrypted Drive Path

Jul 6, 2007



We have an encrypted drive (that can be mounted and dismounted, a third party tool to encrypt drive path). I wanted to store the secondary file to that encrypted drive path. The secondary file stores confidential information. I separated the table from the primary to secondary file. Encryption per column is not advisable to do on that table so we decided to separate that table and put it on secondary filegroup. The physical file is stored in the mounted drive path.



I can read and write in that mounted drive path. I can also read and write if the drive is unmounted (which I believe read and write is really being done). When the drive is unmounted, the physical secondary file (.ndf) is not visible to any user logging in the server itself (this is actually the goal why we do this encrypted drive setup thing). It is kept virtually somewhere in the machine. To mount it back, a password is needed.



I'm a bit confuse, somebody can advise or give their insight on this setup. I believe that when the drive is dismounted, SQL Server stored the transactions in cache until it finds that the drive is mounted back. This means that all transactions are not comitted yet. When the drive is mounted back, I think SQL Server is smart enough to check/know that the drive is physically present and will flash all the pending transaction from the cache to the hard drive.



Is my assumption correct? Is there any thing that I need to know about transaction, committed and those data flashing thing on the hard drive?



Thanks in advance....





View 4 Replies View Related

Integration Services :: How To Create Excel File With XSLS Extension

Jun 29, 2015

I use an execute sql task and excel connection manager to craete excel file.

Execute sql task:

In the connection:
 
It works. But when i choose file path to: C:1111.xlsx

And excel version to micorsoft excel 2007. When open the file it created,it promotes the format is not correct. How to solve this?

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved