The SQL backups maybe conflicted with a tape backup running around that time and locking the files/directory?

(just a wild guess though)

...or you might even need to qualify it with the owner name:

Select * from [_SMDBA_].[_Actions_]

Is refiner working ok using the same host command from a command prompt?

When using the command prompt, are you logged on as the same Windows account as MSSQLServer? ...

Actually it's not returning the output of Refiner. It's returning the string "done" in all cases, whether Refiner works ok, fails, or even not there at all.

I don't know of a way to achieve what you're trying to do - that is shrink the 20gb log component of the backup before restoring, or tell restore to...

Just a few that come to mind:

* leaving the sa password null or some ridiculously guessable value

* not having primary keys, or at least unique keys

* not having clustered indexes...

Another criterion for a deterministic function is that it's schema bound. Just add WITH SCHEMABINDING. Eg.

 



drop FUNCTION CREATE_DISP_DATE

go

set ANSI_NULLS on

set QUOTED_IDENTIFIER on

go

create FUNCTION...

Is the .dat file a true SQL 6.5 backup, or maybe the person sent you a device file.

In Query Analyser try:

LOAD HEADERONLY FROM DISK = '<fullpath>.dat'

(eg. LOAD HEADERONLY FROM...

You cannot restore a SQL Server backup to MySQL. You can possibly use DTS or other facilities to transfer data though.

RESTORE database <dbname> FROM device1, device2,device3, device4, device5

Try syntax along the lines of:

 

UPDATE  BLOCKS_HISTORY

set who_sql = text

from BLOCKS_HISTORY, ::fn_get_sql(@who_sql_handle)

WHERE  (dt=@dt) and (who_sql_handle=@who_sql_handle)

I've had no past trouble accessing Access, Excel and Text files using that provider. Have you tried the example in BOL under "OLE DB Provider for Jet"?

How are you logged in during this scenario. What's the result when you run:

select suser_sname()

The simplest action you can take is to remove the builtin/administrators, but make sure you're absolutely sure of the sa password before you do so. You can then restirct...

800mb sounds right. I usually get around 1:5 compression of DB backups too.