renaming .mdf to .ldf

While moving tempdb, I have accidentally named templog file templog.mdf.
Now my SQL wouldn't start, it's throwing me this:
"The SQL Server (MSSQLSERVER) service terminated with service-specific error
1814 (0x716)."
Please help...
Rename it back to *.ldf.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in
message news:DB670DBE-AAE2-4C17-802B-9E119E5962DC@.microsoft.com...
> While moving tempdb, I have accidentally named templog file templog.mdf.
> Now my SQL wouldn't start, it's throwing me this:
> "The SQL Server (MSSQLSERVER) service terminated with service-specific
> error
> 1814 (0x716)."
> Please help...
|||SQL Server should just create the templog.ldf file if it's not there, and
comes up online. I'd double check whether the error was due to a renamed
templog.ldf file.
Linchi
"Leon Shargorodsky" wrote:

> While moving tempdb, I have accidentally named templog file templog.mdf.
> Now my SQL wouldn't start, it's throwing me this:
> "The SQL Server (MSSQLSERVER) service terminated with service-specific error
> 1814 (0x716)."
> Please help...
|||Rename it back to *.ldf.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in
message news:DB670DBE-AAE2-4C17-802B-9E119E5962DC@.microsoft.com...
> While moving tempdb, I have accidentally named templog file templog.mdf.
> Now my SQL wouldn't start, it's throwing me this:
> "The SQL Server (MSSQLSERVER) service terminated with service-specific
> error
> 1814 (0x716)."
> Please help...
|||tempdb is recreated every time you start the database so you should be able
to just delete the ldf and mdf files and start it. If this doesn't work
then chances are the SQL service account doesn't have permissions to write
in the new location.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in
message news:DB670DBE-AAE2-4C17-802B-9E119E5962DC@.microsoft.com...
> While moving tempdb, I have accidentally named templog file templog.mdf.
> Now my SQL wouldn't start, it's throwing me this:
> "The SQL Server (MSSQLSERVER) service terminated with service-specific
> error
> 1814 (0x716)."
> Please help...
sql