is it possible to move my sql 2000 database (in C disk) to another disk (Disk) ?

hello,all

I am new to Sql 2000,I installed sql 2000 database in C disk,but Now I found my C disk space is smaller than before,So I want to move my databse(include data and structure) from C Disk to D Disk(its space is very large) .

is it possible to do it ?

if its can be done ,do I need to change my asp.net program source code (exp: chaneg my crystal report connectstring ) ?

thanks in advanced!

You can "detach" the detabase, physically copy/move the files (*.mdf and *.ldf files) to the new location, then "attach" the DB and select the files from the new location. You dont need to change anything on the application level.

Is it OK to Copy Database Backups to Tape Using Compression?

Hi, I back up SQL Server 2000 and SQL server 2005 databases to hard disk using the SQL Server Backup Wizard and maintenance plans. Then, I copy the resulting backups to tape using third party tape backup software and compression by the backup software and hardware. I do not use the SQL Server Agent available for the third party backup software. Is this acceptable, or does the compression performed by the third party backup system introduce opportunities for database corruption or other negative effects?

Thanks

Hello,

This is completely acceptable - provided of course that the software you are using is reputable and that you have tested restoration succesfully.

Cheers
Rob

Is it best practice to put both the SQL & MSDTC groups on the same node?

In Rodney R. Fournier's blog it states:
"If MSDTC is used with SQL, you should ensure it is in it's own group,
on it's own disk resource. Lastly, Microsoft recommends to run the
MSDTC & SQL group on the same node, and that the MSDTC is brought
online first when the groups are moved."
("http://msmvps.com/clustering/archive/2004/10/25/16672.aspx").
I have a couple of questions about this but let first list my
assumptions.
Best:
For high performance, installing an MSDTC Resource to it in its own
group. This group should have its own disk and IP resources.
Good:
The next best method is to put the MSDTC resource in the cluster or
quorum group.
Worse:
Put the MSDTC resource in SQL Group.
What are the reasons for running the MSDTC & SQL group on the same
node, beyond these potential Win2003 cluster issues listed in:
http://support.microsoft.com/default...b;en-us;889706
http://support.microsoft.com/kb/821751/
?
If DTC is in the quorum group is it still best to put SQL and quorum
group on the same node?
Our system admin is religious about putting the SQL group on a
different node from the Quorum & DTC groups. Is there a best practice
here or a KB I can point to?
Are there any implications not having SQL dependent of MSDTC starting
first (MSDTC is brought online first when the groups are moved)
beyond the possibility of not being able to start a distributed
transaction?
Replies below...
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
"Sean" <spowell71@.hotmail.com> wrote in message
news:1126723915.556530.64310@.g44g2000cwa.googlegro ups.com...
> In Rodney R. Fournier's blog it states:
> "If MSDTC is used with SQL, you should ensure it is in it's own group,
> on it's own disk resource. Lastly, Microsoft recommends to run the
> MSDTC & SQL group on the same node, and that the MSDTC is brought
> online first when the groups are moved."
> ("http://msmvps.com/clustering/archive/2004/10/25/16672.aspx").
> I have a couple of questions about this but let first list my
> assumptions.
> Best:
> For high performance, installing an MSDTC Resource to it in its own
> group. This group should have its own disk and IP resources.
>
Correct.

> Good:
> The next best method is to put the MSDTC resource in the cluster or
> quorum group.
>
Correct.

> Worse:
> Put the MSDTC resource in SQL Group.
>
Yuck! Correct.

> What are the reasons for running the MSDTC & SQL group on the same
> node, beyond these potential Win2003 cluster issues listed in:
> http://support.microsoft.com/default...b;en-us;889706
> http://support.microsoft.com/kb/821751/
> ?
>
Correct, pre SP1 for Windows Server 2003 MSDTC has issues! Lots of issues.
The Q is correct.

> If DTC is in the quorum group is it still best to put SQL and quorum
> group on the same node?
>
If you can, yes!

> Our system admin is religious about putting the SQL group on a
> different node from the Quorum & DTC groups. Is there a best practice
> here or a KB I can point to?
>
http://support.microsoft.com/default...b;en-us;889706
Remember, SQL does not require MSDTC. You only need it if you application
will use it.

> Are there any implications not having SQL dependent of MSDTC starting
> first (MSDTC is brought online first when the groups are moved)
> beyond the possibility of not being able to start a distributed
> transaction?
>
Isn't that enough?
|||What are the arguments against these types of statements?
Having Quorum & DTC groups on a different node than the SQL group
a) has a load balancing effect, i.e. the SQL group will have the full
physical resources of the node.
b) enables the failover of SQL group happen be quicker cause Quorum &
DTC groups are already on the failover node.
|||http://support.microsoft.com/default...b;en-us;889706 pretty much
covers it.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
"Sean" <spowell71@.hotmail.com> wrote in message
news:1126789871.591787.32620@.g44g2000cwa.googlegro ups.com...
> What are the arguments against these types of statements?
> Having Quorum & DTC groups on a different node than the SQL group
> a) has a load balancing effect, i.e. the SQL group will have the full
> physical resources of the node.
> b) enables the failover of SQL group happen be quicker cause Quorum &
> DTC groups are already on the failover node.
>
|||I had this problem, MSTDC not available so I put MSDTC in the same group as
SQLServer AND made SQLServer dependant on MSDTC Works fine now.
Nik Marshall-Blank MCSD/MCDBA
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:%23sx340fuFHA.3188@.TK2MSFTNGP14.phx.gbl...
> http://support.microsoft.com/default...b;en-us;889706 pretty much
> covers it.
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://www.msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
>
> "Sean" <spowell71@.hotmail.com> wrote in message
> news:1126789871.591787.32620@.g44g2000cwa.googlegro ups.com...
>