October 29, 2010 at 2:41 pm
Hi,.
In the log shipping scenario, on secondary server , I noticed that there is no mdf file for 2 databases, instead of it there is .bak file........they both have a ldf file too
Both those databases are in standby read only mode..
What is it going on?
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
October 30, 2010 at 6:24 am
Why do you say they have no .MDF ? Look at the properties of the database to see what it's using for .MDF files. Maybe they are named differently than you are expecting.
October 30, 2010 at 12:30 pm
It's possible that the person who set this up created the data files using .BAK as the extension. You can validate what files are being used by:
SELECT * FROM sys.master_files;
If that is the case, there really isn't any problems - because SQL Server does not care what the extension is or even if there is one.
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
November 1, 2010 at 7:13 am
I checked the output of that query;
In the name column, it says dbname.mdf
but in the physical name column, it says c:\dbname.bak
How did it happen automatically, it changed from .mdf to .bak
I never changed it.
I checked on the primary server (from where iam doing log shipping) and there all extensions are correct..
Also,
one of the database physical name is C:\dbname.mdf.mdf
How can I rename it?
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
November 1, 2010 at 7:30 am
It didn't happen by itself. It happened when log shipping was set up and the database was restored on that system.
You can't change it now without rebuilding log shipping. To rename the files you have to take the database offline.
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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply