Control panel, folder options, file types, find the .bak extension reference and delete this from the associated file list.

HTH

David

We actually do a combination of both Steve's and Andy's idea in that we have a dedicated server which EM is installed on and we give our developers TS connection...

Thanks Steve! Should have specified msdb in my last post.

David

Yes, you would need to recover the system databases in order to get the DTS packages back. As to the 7.0 restore to 2000 on the system databases the answer...

Bill,

Steve Jones posted these two articles (actually one - the other is the answers to the quiz) on "who do you hire". I actually used this in a recent interview...

Yes, it copies all aspects of that database.

Glad to help.

David

The .mdf file is the database file however, the file size does not necessarily tell you how much data is in the file. So, when you insert 20 K into...

I use SQL backup to disk and then backup the SQL backup file to tape with Veritas. I just pass on the direct Veritas connector to SQL to perform the...

Christine,

Most of the TechNet articles that I have seen about that error claim fix in SP2. Have you reinstalled the service pack yet to see if that clears your...

Ken Henderson writes a good book called "Guru's Guide to Transact-SQL". There is also the book by Itzik Ben-Gan and Tom Moreau titled "Advanced Transact-SQL for SQL Server 2000". Both...

Love 'em

and

Hate 'em - or better yet nervous about where they are going which is everywhere.

Consider the ease in which we are able to maintain a DBMS...

I know there is a add-in that needs to be installed on the SQL Server that allows backup exec to connect to the DBMS. Should be supplied by Veritas, at...

I have a stored proc that goes out and kills all connections to that database. When I did this I was new to SQL and now I would just set...

Christine,

Can you send your configuration including info about how your services are configured, what type of mail client (assuming Outlook), what version of Exchange, Version of SQL and Service Pack?

Are...

Well... Um.... Er.... Bigger bonehead than I thought. Uh, I am, uh, getting the same thing. Need to investigate more.

Some stupid reason I thought I...