June 3, 2008 at 4:44 pm
Hello,
What is you only have the .BAK of the database and you don't have an existing .MDF/.LDF files?
If you only have the .BAK, can you create a new database and then restore the .BAK to the new database? You would be using the same name and permission and such. Will this work?
Thank you.
June 3, 2008 at 5:09 pm
You don't need to create the database first. You can perform the restore from the .BAK file and the files will be created.
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
June 3, 2008 at 6:28 pm
Correct, a .bak is used in DR situations. There will be no MDF/LDF. They will be created during the restore process, at the sizes needed for the backups.
You can look at the .bak file with RESTORE WITH HEADERONLY to see the files in there.
June 3, 2008 at 10:55 pm
The .BAK file should contain full database backup.
If it contains only differential backup, it is not enough.
Suresh
June 4, 2008 at 9:27 am
Thanks, I was able to restore the database. It was a full database backup.
June 5, 2008 at 7:32 am
Any Database backup file can be restore anywhere in the server. I mean in any server of SQL. but make sure that .bak file is correct. Sometimes it may be corrupt and you could not able to restore it.
By using .bak fiile you can have DR Solution or else you can develop DEV/TEST/UAT/SIT environment. The same thing with the DEV REFRESHMENT. You do the same thing to make DEV in SYNC.
MCP, MCTS (GDBA/EDA)
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply