Move transaction logs in SQL cluster

Hi
I need to move the transaction logs for all the sql db's (including master,
model and user db's etc) to a seperate drive. Does anyone have any experience
doing this in a sql cluster?
Thanks
Parky
Parky wrote:
> Hi
> I need to move the transaction logs for all the sql db's (including
> master, model and user db's etc) to a seperate drive. Does anyone
> have any experience doing this in a sql cluster?
There is no difference if you move t-log in a single box machine or in a
cluster environment.
You have to pay attention to move db files ONLY on shared disk and modify,
using EM, the switch -l in startup properties of SQL Server and assign them
the new location of t-log of master database

> Thanks
Bye
Luca Bianchi
Microsoft MVP - SQL Server
http://mvp.support.microsoft.com
http://italy.mvps.org
|||Hello Parky,
I agree with Luca. There is no difference between moving the db files on a standalone SQL server v/s clustered SQL Server. One difference is that the shared dirve where you want to move the db files should be in
the dependency list of SQL Server resource. (For Ex. Say you want to move the Tlogs to a shared drive F:. Make sure that SQL Server resource has F: as a dependency. If not you will have have make it. Note that
this requires a downtime as you will have to take SQL Server resource offline, add the shared drive as a dependency and then take SQL Server online. Then you can use your usual steps (see
http://support.microsoft.com/kb/224071/EN-US/
INF: Moving SQL Server Databases to a New Location using Detach/Attach )
If you have never done this on a cluster, I will recommend you to practice the steps on a test SQL Cluster or a cluster using virtual technology.
HTH,
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||I would leave the System databases and there log file on one drive and split
the user databases to two diffrent databases, that way is you losse the log
drive you can still get sql server running and manage it to recreate the user
databases from the datafiles with diffrent location of the log files.
"Uttam Parui[MS]" wrote:

> Hello Parky,
> I agree with Luca. There is no difference between moving the db files on a standalone SQL server v/s clustered SQL Server. One difference is that the shared dirve where you want to move the db files should be in
> the dependency list of SQL Server resource. (For Ex. Say you want to move the Tlogs to a shared drive F:. Make sure that SQL Server resource has F: as a dependency. If not you will have have make it. Note that
> this requires a downtime as you will have to take SQL Server resource offline, add the shared drive as a dependency and then take SQL Server online. Then you can use your usual steps (see
> http://support.microsoft.com/kb/224071/EN-US/
> INF: Moving SQL Server Databases to a New Location using Detach/Attach )
> If you have never done this on a cluster, I will recommend you to practice the steps on a test SQL Cluster or a cluster using virtual technology.
> HTH,
> Best Regards,
> Uttam Parui
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>
>

move or upgrade MSDE to Sql server 2000 server

We have 3 MSDE databases (3 seperate servers) which we need to make into one Sql 2000 server (new server). How is this done? Can't find anything clear about this.
ThanksWe have 3 MSDE databases (3 seperate servers) which we need to make into one Sql 2000 server (new server). How is this done? Can't find anything clear about this.

Thanks
See this http://support.microsoft.com/default.aspx?scid=kb;en-us;815013#2 (http://support.microsoft.com/default.aspx?scid=kb;en-us;815013#2)|||Let's say I understand that MS site. How do the 3 MSDE databases get into 1 SQL database?

Thanks...|||Let's say I understand that MS site. How do the 3 MSDE databases get into 1 SQL database?

Thanks...
Oops!! Sorry,its my mistake ,I paste the wrong link .Please see this one...
http://sqlserver2000.databases.aspfaq.com/how-do-i-upsize-my-msde-database-to-full-blown-sql-server-2000.html (http://sqlserver2000.databases.aspfaq.com/how-do-i-upsize-my-msde-database-to-full-blown-sql-server-2000.html)
It may help you...

Move Logs to another drive

Does anyone know how to move the SQL logs to another drive. I want to
seperate these from the database for redundancy and performance
I get an error stating the log cannot be moved after the database has been
create.
SQL 2000 STD
Thanks in advance for your helpSee sp_detach/ sp_attach in BOL.
"Bob Smith" <BobSmith@.discussions.microsoft.com> wrote in message
news:D14C7D37-BCF5-4D79-ACCE-95C1F75C4783@.microsoft.com...
> Does anyone know how to move the SQL logs to another drive. I want to
> seperate these from the database for redundancy and performance
> I get an error stating the log cannot be moved after the database has been
> create.
> SQL 2000 STD
> Thanks in advance for your help|||"Bob Smith" <BobSmith@.discussions.microsoft.com> wrote in message
news:D14C7D37-BCF5-4D79-ACCE-95C1F75C4783@.microsoft.com...
> Does anyone know how to move the SQL logs to another drive. I want to
> seperate these from the database for redundancy and performance
> I get an error stating the log cannot be moved after the database has been
> create.
> SQL 2000 STD
> Thanks in advance for your help
sp_attach_db and sp_detach_db can help you here.
Alternately, you could issue a RESTORE DATABASE command specify the new
location using the MOVE TO option.
Rick Sawtell
MCT, MCSD, MCDBA

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/default.aspx?scid=kb;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/default.aspx?scid=kb;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
>

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:
>