SQL Server 2000 shrink remote log file

SQL Server 2000 shrink remote log file

Post by dpeji » Thu, 21 Aug 2003 02:04:37



Hi All,

Is it possible to shrink log file on remote database (create job on
server1 to shrink database log file on server2)?

Regards,

Dragomir

--
Posted via http://dbforums.com

 
 
 

SQL Server 2000 shrink remote log file

Post by Tibor Karasz » Thu, 21 Aug 2003 12:14:12


You need to get to that server somehow. Either use linked servers and execute a remote stored
procedure which does the shrink, or use a CmdExec jobsstep which uses OSQL agaist the other server
to do the shrink.

--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver


> Hi All,

> Is it possible to shrink log file on remote database (create job on
> server1 to shrink database log file on server2)?

> Regards,

> Dragomir

> --
> Posted via http://dbforums.com


 
 
 

SQL Server 2000 shrink remote log file

Post by dpeji » Fri, 29 Aug 2003 06:44:40


It works.

Thanks Tibor.

--
Posted via http://dbforums.com