Hi,

"you have the Agent for SQL installed and are using it."

Agent, is different from MSSQLAgent? This agent is provided by Veritas? How can I verify this "agent" is running?

Hi,

How is the OS tool able to make copies? I've run tests using win explorer and receive "sharing violations" when i try to copy the data files to another loaction...

Hi,

Veritas Backup Agent for ver 8.6.

Nothing in event viewer or MSSQL error logs ... ?

Using EM? I was hoping for something similar to ORACLE, which allows you to move objects to new filegroups/tablespaces using the ALTER syntax for the given object type ie: table/index....

newbie ... many thanks!!! Works like a charm... Jeff

Is ther not a statement like:

ALTER TABLE MyTable ON [NewFileGroup]

??

Hi, thanks. But I'm not creating new tables ... I want to ALTER the existing tables ... ???

HI,

Thanks to everyone's responses. One question .. the "?" .. is this a placeholder that will insert all the tables in the follwing:

SET @TempSQL = 'sp_msforeachtable "Alter Table ? NOCHECK...

Great. Thanks. Any idea why these won't script when using EM "Generate SQL Script"? All the 16's do (I assume they mean clustered PK?)

Hi,

The version is MSSQL2000. I followed the link and have previously done those steps. Do you have the links for microsoft? THe log hasn't been dumped in 6months. Its for...

What do you mean by more resources? Thanks.

"In this case if you can't change the process, you'll need more resources to handle the request.".

Hi,

More background - Our Network Administrator takes an OS copy of all files on the drive to tape that contains the MDF and LDF files. His position is that if a...

Hi,

The memory is configured as per default installation. No changes have been made. There are 32 databases ... 3 are big and consume 2/3 of disk. Plus users from these...

Hi,

I'm using SQL 7 EM. All servers with the red squiggly lines are running ...

Hi,

Any suggestions as to what "events" I should add when I set up my trace within SQL Profiler?

THanks. Jeff