moving a database

Using SS2000 SP3. I'm trying to move a database using:
EXEC sp_detach_db 'vesta_archive', 'false'
but I get a "cannot detach the database 'vesta_archive' because it is
currently in use."
There is no one here and no dts packages running. Is there any way to tell
who might be using the database or is there maybe another reason for this
message?
Thanks,
--
Dan D.Try sp_who, and then look at column loginame, and dbname column.
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:7D0CBB5C-EC60-447E-A465-DDC14FD436FC@.microsoft.com...
> Using SS2000 SP3. I'm trying to move a database using:
> EXEC sp_detach_db 'vesta_archive', 'false'
> but I get a "cannot detach the database 'vesta_archive' because it is
> currently in use."
> There is no one here and no dts packages running. Is there any way to tell
> who might be using the database or is there maybe another reason for this
> message?
> Thanks,
> --
> Dan D.|||Dan,
When I get such a message it is often me.
Do you have Enterprise manager open to that database? Another Query
Analyzer panel that is in that database? Etc?
Russell Fields
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:7D0CBB5C-EC60-447E-A465-DDC14FD436FC@.microsoft.com...
> Using SS2000 SP3. I'm trying to move a database using:
> EXEC sp_detach_db 'vesta_archive', 'false'
> but I get a "cannot detach the database 'vesta_archive' because it is
> currently in use."
> There is no one here and no dts packages running. Is there any way to tell
> who might be using the database or is there maybe another reason for this
> message?
> Thanks,
> --
> Dan D.|||Thanks. I found the culprit.
"Gregory A. Larsen" wrote:

> Try sp_who, and then look at column loginame, and dbname column.
> --
> ----
--
> ----
--
> --
> Need SQL Server Examples check out my website at
> http://www.geocities.com/sqlserverexamples
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:7D0CBB5C-EC60-447E-A465-DDC14FD436FC@.microsoft.com...
>
>|||Thanks. I found the person.
"Russell Fields" wrote:

> Dan,
> When I get such a message it is often me.
> Do you have Enterprise manager open to that database? Another Query
> Analyzer panel that is in that database? Etc?
> Russell Fields
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:7D0CBB5C-EC60-447E-A465-DDC14FD436FC@.microsoft.com...
>
>|||Russell, I agree. It's often the DBA. Sometimes even if you switch the
highlight to a non database object in Enterprise Manager, sp_who2 still
shows you are connected. In this case, I have to disconnect ...
"Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
news:%23s7UjDfhEHA.1184@.TK2MSFTNGP12.phx.gbl...
> Dan,
> When I get such a message it is often me.
> Do you have Enterprise manager open to that database? Another Query
> Analyzer panel that is in that database? Etc?
> Russell Fields
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:7D0CBB5C-EC60-447E-A465-DDC14FD436FC@.microsoft.com...
tell[vbcol=seagreen]
this[vbcol=seagreen]
>|||More information needed than this.|||Arc Serve has a database containing the information of the datastore
including indexes references etc. This is needed if a restore is going t
o
be done. I would like this database that arcserve creates to be put into
an SQL database, instead of residing on my local drive.
"unc27932@.yahoo.com" wrote:

> More information needed than this.
>

moving a database

Using SS2000 SP3. I'm trying to move a database using:
EXEC sp_detach_db 'vesta_archive', 'false'
but I get a "cannot detach the database 'vesta_archive' because it is
currently in use."
There is no one here and no dts packages running. Is there any way to tell
who might be using the database or is there maybe another reason for this
message?
Thanks,
Dan D.
Try sp_who, and then look at column loginame, and dbname column.
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:7D0CBB5C-EC60-447E-A465-DDC14FD436FC@.microsoft.com...
> Using SS2000 SP3. I'm trying to move a database using:
> EXEC sp_detach_db 'vesta_archive', 'false'
> but I get a "cannot detach the database 'vesta_archive' because it is
> currently in use."
> There is no one here and no dts packages running. Is there any way to tell
> who might be using the database or is there maybe another reason for this
> message?
> Thanks,
> --
> Dan D.
|||Dan,
When I get such a message it is often me.
Do you have Enterprise manager open to that database? Another Query
Analyzer panel that is in that database? Etc?
Russell Fields
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:7D0CBB5C-EC60-447E-A465-DDC14FD436FC@.microsoft.com...
> Using SS2000 SP3. I'm trying to move a database using:
> EXEC sp_detach_db 'vesta_archive', 'false'
> but I get a "cannot detach the database 'vesta_archive' because it is
> currently in use."
> There is no one here and no dts packages running. Is there any way to tell
> who might be using the database or is there maybe another reason for this
> message?
> Thanks,
> --
> Dan D.
|||Thanks. I found the culprit.
"Gregory A. Larsen" wrote:

> Try sp_who, and then look at column loginame, and dbname column.
> --
> ----
> ----
> --
> Need SQL Server Examples check out my website at
> http://www.geocities.com/sqlserverexamples
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:7D0CBB5C-EC60-447E-A465-DDC14FD436FC@.microsoft.com...
>
>
|||Thanks. I found the person.
"Russell Fields" wrote:

> Dan,
> When I get such a message it is often me.
> Do you have Enterprise manager open to that database? Another Query
> Analyzer panel that is in that database? Etc?
> Russell Fields
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:7D0CBB5C-EC60-447E-A465-DDC14FD436FC@.microsoft.com...
>
>
|||Russell, I agree. It's often the DBA. Sometimes even if you switch the
highlight to a non database object in Enterprise Manager, sp_who2 still
shows you are connected. In this case, I have to disconnect ...
"Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
news:%23s7UjDfhEHA.1184@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> Dan,
> When I get such a message it is often me.
> Do you have Enterprise manager open to that database? Another Query
> Analyzer panel that is in that database? Etc?
> Russell Fields
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:7D0CBB5C-EC60-447E-A465-DDC14FD436FC@.microsoft.com...
tell[vbcol=seagreen]
this
>
|||More information needed than this.
|||Arc Serve has a database containing the information of the datastore
including indexes references etc. This is needed if a restore is going to
be done. I would like this database that arcserve creates to be put into
an SQL database, instead of residing on my local drive.
"unc27932@.yahoo.com" wrote:

> More information needed than this.
>

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 db

Hi
I have WIn2003 SP1+SQL2000 SP3.
Al the DB sites on drive D, I installed new HD Edrive.
I need to move all the DB to the new drive.
What is the best to do that?
Than'x
Shay
http://www.webservertalk.com/archive132-2004-7-330935.html
Aaron Bertrand
SQL Server MVP
"S" <s@.s.com> wrote in message news:uF11vLf2HHA.5740@.TK2MSFTNGP04.phx.gbl...
> Hi
> I have WIn2003 SP1+SQL2000 SP3.
> Al the DB sites on drive D, I installed new HD Edrive.
> I need to move all the DB to the new drive.
> What is the best to do that?
> Than'x
> Shay
>
|||Search the Books On Line (BOL) for Detach and Attach:
Quoting BOL:
To move a database, or database file, to another server or disk:
1) Detach the database.
2) Move the database file(s) to the other server or disk.
3) Attach the database specifying the new location of the moved
file(s).
My only additional comment is that I would have really good backups
first, and I would COPY rather than MOVE, only getting rid of the
oroginal files after the database is working from the new location.
Roy Harvey
Beacon Falls, CT
On Wed, 8 Aug 2007 22:32:15 +0200, "S" <s@.s.com> wrote:

>Hi
>I have WIn2003 SP1+SQL2000 SP3.
>Al the DB sites on drive D, I installed new HD Edrive.
>I need to move all the DB to the new drive.
>What is the best to do that?
>Than'x
>Shay
>
|||On Aug 8, 2:44 pm, Roy Harvey <roy_har...@.snet.net> wrote:
> Search the Books On Line (BOL) for Detach and Attach:
> Quoting BOL:
> To move a database, or database file, to another server or disk:
> 1) Detach the database.
> 2) Move the database file(s) to the other server or disk.
> 3) Attach the database specifying the new location of the moved
> file(s).
> My only additional comment is that I would have really good backups
> first, and I would COPY rather than MOVE, only getting rid of the
> oroginal files after the database is working from the new location.
> Roy Harvey
> Beacon Falls, CT
>
> On Wed, 8 Aug 2007 22:32:15 +0200, "S" <s...@.s.com> wrote:
>
>
>
> - Show quoted text -
I agree with the detach and attach method in this case. You should
simply detach the database(s) you wish to move, move the files to
their new location, the simply run the attach method. It will ask you
to browse for your .mdf and .ldf files and voila, you will be done.

Move db

Hi
I have WIn2003 SP1+SQL2000 SP3.
Al the DB sites on drive D, I installed new HD Edrive.
I need to move all the DB to the new drive.
What is the best to do that?
Than'x
Shayhttp://www.webservertalk.com/archiv...4-7-330935.html
Aaron Bertrand
SQL Server MVP
"S" <s@.s.com> wrote in message news:uF11vLf2HHA.5740@.TK2MSFTNGP04.phx.gbl...
> Hi
> I have WIn2003 SP1+SQL2000 SP3.
> Al the DB sites on drive D, I installed new HD Edrive.
> I need to move all the DB to the new drive.
> What is the best to do that?
> Than'x
> Shay
>|||Search the Books On Line (BOL) for Detach and Attach:
Quoting BOL:
To move a database, or database file, to another server or disk:
1) Detach the database.
2) Move the database file(s) to the other server or disk.
3) Attach the database specifying the new location of the moved
file(s).
My only additional comment is that I would have really good backups
first, and I would COPY rather than MOVE, only getting rid of the
oroginal files after the database is working from the new location.
Roy Harvey
Beacon Falls, CT
On Wed, 8 Aug 2007 22:32:15 +0200, "S" <s@.s.com> wrote:

>Hi
>I have WIn2003 SP1+SQL2000 SP3.
>Al the DB sites on drive D, I installed new HD Edrive.
>I need to move all the DB to the new drive.
>What is the best to do that?
>Than'x
>Shay
>|||On Aug 8, 2:44 pm, Roy Harvey <roy_har...@.snet.net> wrote:
> Search the Books On Line (BOL) for Detach and Attach:
> Quoting BOL:
> To move a database, or database file, to another server or disk:
> 1) Detach the database.
> 2) Move the database file(s) to the other server or disk.
> 3) Attach the database specifying the new location of the moved
> file(s).
> My only additional comment is that I would have really good backups
> first, and I would COPY rather than MOVE, only getting rid of the
> oroginal files after the database is working from the new location.
> Roy Harvey
> Beacon Falls, CT
>
> On Wed, 8 Aug 2007 22:32:15 +0200, "S" <s...@.s.com> wrote:
>
>
>
>
>
> - Show quoted text -
I agree with the detach and attach method in this case. You should
simply detach the database(s) you wish to move, move the files to
their new location, the simply run the attach method. It will ask you
to browse for your .mdf and .ldf files and voila, you will be done.

Move db

Hi
I have WIn2003 SP1+SQL2000 SP3.
Al the DB sites on drive D, I installed new HD Edrive.
I need to move all the DB to the new drive.
What is the best to do that?
Than'x
Shayhttp://www.webservertalk.com/archive132-2004-7-330935.html
--
Aaron Bertrand
SQL Server MVP
"S" <s@.s.com> wrote in message news:uF11vLf2HHA.5740@.TK2MSFTNGP04.phx.gbl...
> Hi
> I have WIn2003 SP1+SQL2000 SP3.
> Al the DB sites on drive D, I installed new HD Edrive.
> I need to move all the DB to the new drive.
> What is the best to do that?
> Than'x
> Shay
>|||Search the Books On Line (BOL) for Detach and Attach:
Quoting BOL:
To move a database, or database file, to another server or disk:
1) Detach the database.
2) Move the database file(s) to the other server or disk.
3) Attach the database specifying the new location of the moved
file(s).
My only additional comment is that I would have really good backups
first, and I would COPY rather than MOVE, only getting rid of the
oroginal files after the database is working from the new location.
Roy Harvey
Beacon Falls, CT
On Wed, 8 Aug 2007 22:32:15 +0200, "S" <s@.s.com> wrote:
>Hi
>I have WIn2003 SP1+SQL2000 SP3.
>Al the DB sites on drive D, I installed new HD Edrive.
>I need to move all the DB to the new drive.
>What is the best to do that?
>Than'x
>Shay
>|||On Aug 8, 2:44 pm, Roy Harvey <roy_har...@.snet.net> wrote:
> Search the Books On Line (BOL) for Detach and Attach:
> Quoting BOL:
> To move a database, or database file, to another server or disk:
> 1) Detach the database.
> 2) Move the database file(s) to the other server or disk.
> 3) Attach the database specifying the new location of the moved
> file(s).
> My only additional comment is that I would have really good backups
> first, and I would COPY rather than MOVE, only getting rid of the
> oroginal files after the database is working from the new location.
> Roy Harvey
> Beacon Falls, CT
>
> On Wed, 8 Aug 2007 22:32:15 +0200, "S" <s...@.s.com> wrote:
> >Hi
> >I have WIn2003 SP1+SQL2000 SP3.
> >Al the DB sites on drive D, I installed new HD Edrive.
> >I need to move all the DB to the new drive.
> >What is the best to do that?
> >Than'x
> >Shay- Hide quoted text -
> - Show quoted text -
I agree with the detach and attach method in this case. You should
simply detach the database(s) you wish to move, move the files to
their new location, the simply run the attach method. It will ask you
to browse for your .mdf and .ldf files and voila, you will be done.