Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-01-12 : 08:58:07
|
| Bipan writes "Can we create .bak file from .mdf and .ldf file if database is not present but physical file's like .mdf and .ldf backup is with us?" |
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2006-01-12 : 13:47:03
|
| What I think you're asking is the following:If I have a .mdf and .ldf, but they're not attached to a SQL Server instance, can I create a database backup from them?The answer is no.RegardsPaul RandalLead Program Manager, Microsoft SQL Server Storage Engine(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-01-12 : 14:22:39
|
| ... but you could presumably ATTACH the files to a suitable server, and then back them up to make the .BAK, and then detatch the database again.Kristen |
|
|
|
|
|
|
Backups