Hi

The "uncompress" actually happens inside the SQL Engine - so no additional space is required for a "temp" file. The only space required is the size of the Database and...

Hi

On your 2 questions:

1) Space on Tape: if your tape device does compression on the fly as ours does. Our usual space saving is approx 65% when going onto tape.

This...

great to hear - al the best

Have you tried loggin into Query Analyzer - do you get the same results?

Another option is to try connect using osql - see if this is also the same.

How about...

Sorry for the confusion, let me explain:

net use q: \\172.16.10.96\sfs p@ssword /user:jhb_sfs_xp\sfsjhb

sfs - this is the folder that has been shared - if you browse to \\172.16.10.96 - then you...

Hi

The details around what we did is as follows:

Step 1 of a SQL Job is to create a map of the drive letter Q using:

net use q: \\172.16.10.96\sfs p@ssword /user:jhb_sfs_xp\sfsjhb

the...

Hi

That sounds very strange. The way I would troubleshoot this is as follows:

* Check the services on each server and check the instance name in brackets - I have seen...

I am not too sure what will hapen to the snapshot when a restore over the database is attempted?

Kevin

in BOL there is a way to protect tables from being dropped - maybe this can be tested for restore operations?

CREATE TRIGGER safety

ON DATABASE

FOR DROP_TABLE, ALTER_TABLE

AS

...

There are DDL Triggers that can protect objects - but not sure if a RESTORE would be covered or if this type of trigger could be applied at the DB...

There are a few things that you should do:

* Find out the company's name - do research on the company - also check the field the company is in

*...

Note: try to avoid a DBA job for a company that has an extreemly small SQL Server database that requires no maintenance or projects around the SQL Server. Let me...

Hi

The reality of being a DBA in a small to medium sized company is that the company usually does not want to spend money on additional resources if they do...

The support guy with me here says he had a call open with Microsoft and he downloaded a tool for IIS relating or checking kerberos errors etc.

The guy at Microsoft...

Thanks for the feedback - we are all learning from the feedback.

There is an actual exe for EM in the binn folder - maybe also trying to launch that directly...