Agreed...I have just had to go and check the CD myself....there it is in the books directory....and why BI for the category??

Sort it out.. :->

Dan,

There is an excellent script in the library that will solve your problem - sp_force_shrink_log'. I have used this on several occations - it works!

Tim

Here is a copy:

use master

go

if...

Greg - Thanks...

I had always assumed that because you could not browse to the drive when creating the device in SQL7, that you could not use a network share.

Typing...

Run 'select @@version'against the master db

(results in text is easier to read!)

Tim

Yes

Map a drive to the location you want to back up to

Create a backup device with the file path to the location (you can browse to the location)

I just wish...

If your looking for a tool to generate a script that will sync the SQLdata checkout SQLDatacompare

http://www.red-gate.com/sql_tools.htm

As for the file system - many options Robocopy?

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q160513&

Hope...

Take a look at UpdateExpert - (St. Bernards Software) if you need to manage patching on multiple servers

Tim

I evaluated the product whist it was in beta.

It did what it said - appeared to be based on transactional replication. It needs loads of disk space; it crates...

On the second point....

If you issue the DBCC SHRINKFILE command for the log file, SQL Server will mark a shrinkpoint in the log but no actual shrinking will take place...

Can you provide more detail on this - what flavour replication?

Where does it fall down?

I have set up replication over the Internet using TCP/IP with no issues (other than security!)

Tim

...

Andy

Have you tried the script above ...it does what it says on the tin...We have used it to great effect in similar situations

Tim

I use SQL 7 Maintenance plans all over the place - the only issues i have has been incorrec configuration.

For example including "attempt to repair minor problems" in the Database...

Technical Comparison of Oracle and MS Sql Server 2000

-------------------------------------------------------------

By Faulkner, Kent, USA

Updated by PorusHH, Australia

Version 3.4, August...

In answer to my own question above, I recieved a mail form MS support yesterday. The two Q articles are very informative - and I am now running the...

The pricing guide as supplied to me by Eyal Aharon of Incepto Ltd is as follows - this was back in March prior to release, so the pricing may be...