The database does have a log file. I should be able to back it up. What do I have to do to accomplish that?

(I understand the advice to...

Excellent question; I wish the answer was so elegant:

The Systems group at my company has recently installed a new Veritas disk-to-disk backup system. The SQL agent for this system...

Thanks, that seems like good advice.

Here is a method that utilizes the proc "xp_FixedDrives" as a convenient tool to query every server (and also send valuable info on drive space):

Declare @cmd varchar(500)

Declare @svr...

Hi Kusum,

I can't think of any reason that you should not be able to modify the job via the PROPERTIES menu (assuming that your login has the necessary permissions). ...

Kusum,

Now I understand what you are seeing, and I agree that it's a surprising problem.

While you have Mgmt Studio open, could you click on New Query, and run the command...

Hello kusum.shah,

Could you provide more information. Did you attempt to modify the job using the GUI (SQL Server Mgmt Studio), or did you attempt it using T_SQL code, or...

Perhaps you could modify the code below to test the permissions of your new user.

Select sUser_sName() -- should give you the name of current user

Execute as Login='' -- insert...

Yes, I did use the sa login in my test, following the example that Cerrudo gave in his white paper. (BTW--my original citation actually points to another of his...

Venu--

It sounds like you are on the right track. It is definitely a good idea to practice restoring your backups.

I would suggest that you create a test...

Running the query: Select name, is_broker_enabled from sys.databases

yields a 0 for the databases that do not have Server Broker enabled. This is true whether I run the query from...

Got it. Thanks. I didn't think that "dbo" applied to a system table.

BTW--I have several jobs that depend on dynamically creating a query to check Information_schema where the...

Thanks.

I can see how to use sysobjects and syscolumns locally, how are they addressed cross-server?

Elliott

"How do people verify that a mirrored database is ready to go (accurate?) in the event of failover?"

I guess it's somewhat an article of faith. You can check the...

Way to go, Aaron!!

We'll see you in the forums.

Elliott