|
Home > Archive > MS SQL Server > November 2006 > renaming .mdf to .ldf
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
renaming .mdf to .ldf
|
|
| Leon Shargorodsky 2006-11-08, 7:12 pm |
| 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...
| |
| Arnie Rowland 2006-11-08, 7:12 pm |
| 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@dis
cussions.microsoft.com> wrote in
message news:DB670DBE-AAE2-4C17-802B- 9E119E5962DC@microso
ft.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...
| |
| Linchi Shea 2006-11-08, 7:12 pm |
| 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...
| |
| Arnie Rowland 2006-11-08, 7:12 pm |
| 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@dis
cussions.microsoft.com> wrote in
message news:DB670DBE-AAE2-4C17-802B- 9E119E5962DC@microso
ft.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...
| |
| Roger Wolter[MSFT] 2006-11-08, 7:12 pm |
| 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@dis
cussions.microsoft.com> wrote in
message news:DB670DBE-AAE2-4C17-802B- 9E119E5962DC@microso
ft.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...
|
|
|
|
|