Move LDF -Has anyone seen this happen?

Hi

We have a SQL 2000 (sp3) server with a database that I set up to have the
MDF on D: and the LDF on E:. All was going along fine for several months and
one day the server rebooted. The SQL log says something like "Service is
shutting down due to server shutdown."

When it came back up the LDF File was on D: (in the same folder as the MDF).
The original LDF was gone from E:

The SQL Log doesn't ever say anything like "Recreating LDF in default
location." or any anything else that would explain what happened.

I assume the change happened during the reboot (actually I didn't notice it
until a week and a half later). I am relatively sure no human did anything
that caused the log file to move.

So has anyone seen this happen before.?

TIA

-Dick"DickChristoph" <dchristo101@.yahoo.com> wrote in message
news:hRBbb.19675$pU4.6621@.twister.rdc-kc.rr.com...
> Hi
> We have a SQL 2000 (sp3) server with a database that I set up to have the
> MDF on D: and the LDF on E:. All was going along fine for several months
and
> one day the server rebooted. The SQL log says something like "Service is
> shutting down due to server shutdown."
> When it came back up the LDF File was on D: (in the same folder as the
MDF).
> The original LDF was gone from E:
> The SQL Log doesn't ever say anything like "Recreating LDF in default
> location." or any anything else that would explain what happened.
> I assume the change happened during the reboot (actually I didn't notice
it
> until a week and a half later). I am relatively sure no human did anything
> that caused the log file to move.
> So has anyone seen this happen before.?

Nope.

I can't think of a way it would happen w/o human intervention.

You can check the ERRORLOG files for sp_detachdb (I think they show up
there).
You should have the last 4 and the current one.

> TIA
> -Dick
>
>

Move Database

Hi
We are running RMS Server and the SQL in the same server (only for RMS), we
like to seperate the SQL in to other server. (just RMS will be in the same
server and settings, except SQL database).
How we do that? just simply take backup and restore? or anything we have to
do?
Thanx
Gopi
Gopi
http://support.microsoft.com/default...n-us;Q314546#9 -- Move
Databases between computers running by sql server
"Gopi" <gopigopi@.hotmail.com> wrote in message
news:uFCVGZCxFHA.2656@.TK2MSFTNGP09.phx.gbl...
> Hi
> We are running RMS Server and the SQL in the same server (only for RMS),
> we like to seperate the SQL in to other server. (just RMS will be in the
> same server and settings, except SQL database).
> How we do that? just simply take backup and restore? or anything we have
> to do?
> Thanx
> Gopi
>
|||Thanx Uri
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OBfvxcCxFHA.1256@.TK2MSFTNGP09.phx.gbl...
> Gopi
> http://support.microsoft.com/default...n-us;Q314546#9 --
> Move Databases between computers running by sql server
>
>
>
> "Gopi" <gopigopi@.hotmail.com> wrote in message
> news:uFCVGZCxFHA.2656@.TK2MSFTNGP09.phx.gbl...
>
|||Try a backup and restore. The run sp_change_users_login as necessary.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:0EA5E1F4-F2D4-4D94-AB1B-C22AB04D7F51@.microsoft.com...
> Hello,
> What is the easiest way to move a database from one server to another with
> the all table structures, view and stored procedures?
> Thanks,
>
|||Hi
Check out http://support.microsoft.com/default...;en-us;Q314546
for the various methods. Watch out for orphaned users as described in the
article.
John
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:0EA5E1F4-F2D4-4D94-AB1B-C22AB04D7F51@.microsoft.com...
> Hello,
> What is the easiest way to move a database from one server to another with
> the all table structures, view and stored procedures?
> Thanks,
>
|||Hi,
1. Backup the database from source sql server using (BACKUP DATABASE
command)
2. COpy the backup file to test server
3. Restore the database in test server (RESTORE DATABASE)
See Backup and Restore commad in books online.
Note:
You can also detach and attach databases. It is fast but require some down
time .
Thanks
Hari
SQL Server MVP
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:0EA5E1F4-F2D4-4D94-AB1B-C22AB04D7F51@.microsoft.com...
> Hello,
> What is the easiest way to move a database from one server to another with
> the all table structures, view and stored procedures?
> Thanks,
>
|||Hi Hari, does Backup/Restore copy the table structure and constrains too?
There is no tables crated in the destination database.
Thanks,
"Hari Prasad" wrote:

> Hi,
>
> 1. Backup the database from source sql server using (BACKUP DATABASE
> command)
> 2. COpy the backup file to test server
> 3. Restore the database in test server (RESTORE DATABASE)
>
> See Backup and Restore commad in books online.
> Note:
> You can also detach and attach databases. It is fast but require some down
> time .
>
> --
> Thanks
> Hari
> SQL Server MVP
>
> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
> news:0EA5E1F4-F2D4-4D94-AB1B-C22AB04D7F51@.microsoft.com...
>
>
|||Hi
It is a backup of everything, read more about backup/restore in Books
online. You should have a policy that says you backup your database at
specific times and save them on external media so that in the event of a
system failure you can recover they system to a given level.
John
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:BF9B75D0-5DAE-4922-B64B-8177FC0D0993@.microsoft.com...[vbcol=seagreen]
> Hi Hari, does Backup/Restore copy the table structure and constrains too?
> There is no tables crated in the destination database.
> Thanks,
> "Hari Prasad" wrote:

Move Database

Hi
We are running RMS Server and the SQL in the same server (only for RMS), we
like to seperate the SQL in to other server. (just RMS will be in the same
server and settings, except SQL database).
How we do that? just simply take backup and restore? or anything we have to
do?
Thanx
GopiGopi
http://support.microsoft.com/defaul...en-us;Q314546#9 -- Move
Databases between computers running by sql server
"Gopi" <gopigopi@.hotmail.com> wrote in message
news:uFCVGZCxFHA.2656@.TK2MSFTNGP09.phx.gbl...
> Hi
> We are running RMS Server and the SQL in the same server (only for RMS),
> we like to seperate the SQL in to other server. (just RMS will be in the
> same server and settings, except SQL database).
> How we do that? just simply take backup and restore? or anything we have
> to do?
> Thanx
> Gopi
>|||Thanx Uri
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OBfvxcCxFHA.1256@.TK2MSFTNGP09.phx.gbl...
> Gopi
> http://support.microsoft.com/defaul...en-us;Q314546#9 --
> Move Databases between computers running by sql server
>
>
>
> "Gopi" <gopigopi@.hotmail.com> wrote in message
> news:uFCVGZCxFHA.2656@.TK2MSFTNGP09.phx.gbl...
>|||Try a backup and restore. The run sp_change_users_login as necessary.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:0EA5E1F4-F2D4-4D94-AB1B-C22AB04D7F51@.microsoft.com...
> Hello,
> What is the easiest way to move a database from one server to another with
> the all table structures, view and stored procedures?
> Thanks,
>|||Hi
Check out http://support.microsoft.com/defaul...b;en-us;Q314546
for the various methods. Watch out for orphaned users as described in the
article.
John
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:0EA5E1F4-F2D4-4D94-AB1B-C22AB04D7F51@.microsoft.com...
> Hello,
> What is the easiest way to move a database from one server to another with
> the all table structures, view and stored procedures?
> Thanks,
>|||Hi,
1. Backup the database from source sql server using (BACKUP DATABASE
command)
2. COpy the backup file to test server
3. Restore the database in test server (RESTORE DATABASE)
See Backup and Restore commad in books online.
Note:
You can also detach and attach databases. It is fast but require some down
time .
Thanks
Hari
SQL Server MVP
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:0EA5E1F4-F2D4-4D94-AB1B-C22AB04D7F51@.microsoft.com...
> Hello,
> What is the easiest way to move a database from one server to another with
> the all table structures, view and stored procedures?
> Thanks,
>|||Hi Hari, does Backup/Restore copy the table structure and constrains too?
There is no tables crated in the destination database.
Thanks,
"Hari Prasad" wrote:

> Hi,
>
> 1. Backup the database from source sql server using (BACKUP DATABASE
> command)
> 2. COpy the backup file to test server
> 3. Restore the database in test server (RESTORE DATABASE)
>
> See Backup and Restore commad in books online.
> Note:
> You can also detach and attach databases. It is fast but require some down
> time .
>
> --
> Thanks
> Hari
> SQL Server MVP
>
> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
> news:0EA5E1F4-F2D4-4D94-AB1B-C22AB04D7F51@.microsoft.com...
>
>|||Hi
It is a backup of everything, read more about backup/restore in Books
online. You should have a policy that says you backup your database at
specific times and save them on external media so that in the event of a
system failure you can recover they system to a given level.
John
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:BF9B75D0-5DAE-4922-B64B-8177FC0D0993@.microsoft.com...[vbcol=seagreen]
> Hi Hari, does Backup/Restore copy the table structure and constrains too?
> There is no tables crated in the destination database.
> Thanks,
> "Hari Prasad" wrote:
>