Favor : sp_movedevice Book Online 6.5

Puedes encontrarlo aqui:

http://www.trefz.de/seminare/micros...device.sql


Saludos
Adrian D. Garcia
MCSD
NDSoft Consultoria y Desarrollo

"Paola" wrote in message
news:e07a01c3f010$b5611f90$
Para poder aplicar este procedimiento necesito bajar el
script del sp sp_movedevice pero yo no tengo los book
online del 6.5, alguien me lo podría pasar...
Muchas gracias.


Option 2
Install the sp_movedevice stored procedure from the SQL
Server Books Online (for more information, see the "Moving
a Device" topic in the SQL Server Books Online).
Run sp_helpdevice to determine the device name and current
path.
Run the following command:
sp_movedevice <device_name>, '<new_path>'

NOTE: If you are moving the master database, proceed to
Step 4. Otherwise, skip to Step 8.
In SQL Enterprise Manager, click the Server menu. Click
SQL Server, then click Configure, followed by Parameters.
Change the Master Database File option to reflect the new
location.
In SQL Enterprise Manager, click the Server menu. Click
SQL Server, then Distributed Transaction Coordinator,
followed by Configure.
Change the log drive designation and then click Reset Log.
Stop SQL Server and physically move the device to the new
location.
Start SQL Server and verify that the database is working
properly (for example, that the database is not marked
Suspect).

Gracias Adrian, lo voy a probar.

Puedes encontrarlo aqui:

http://www.trefz.de/seminare/micros...eminare/do

wnload/sp_movedevice.sql

Saludos
Adrian D. Garcia
MCSD
NDSoft Consultoria y Desarrollo

"Paola" wrote in

message

news:e07a01c3f010$b5611f90$
Para poder aplicar este procedimiento necesito bajar el
script del sp sp_movedevice pero yo no tengo los book
online del 6.5, alguien me lo podría pasar...
Muchas gracias.


Option 2
Install the sp_movedevice stored procedure from the SQL
Server Books Online (for more information, see the "Moving
a Device" topic in the SQL Server Books Online).
Run sp_helpdevice to determine the device name and current
path.
Run the following command:
sp_movedevice <device_name>, '<new_path>'

NOTE: If you are moving the master database, proceed to
Step 4. Otherwise, skip to Step 8.
In SQL Enterprise Manager, click the Server menu. Click
SQL Server, then click Configure, followed by Parameters.
Change the Master Database File option to reflect the new
location.
In SQL Enterprise Manager, click the Server menu. Click
SQL Server, then Distributed Transaction Coordinator,
followed by Configure.
Change the log drive designation and then click Reset Log.
Stop SQL Server and physically move the device to the new
location.
Start SQL Server and verify that the database is working
properly (for example, that the database is not marked
Suspect).


.