MSPress has some good books, just not necessarily the ones on certification. Sybex usually has pretty good cert prep books as does ExamCram. The Transcender CD's are also good. Sometimes...

If you're missing a transaction log backup you can only restore up to the one before the missing one. If you do a full once a week and log every...

Doesnt sound good. You're restoring a backup made on the same server? What version of SQL and what sp? Can you access some of the tables?

Andy

http://www.sqlservercentral.com/columnists/awarren/

I gather you're using the DTS Import/Export wizard, not just the Copy DB Wizard? There is a difference since you can't attach a sql db to Oracle, you'd have to...

Code works on both my workstation which is not in a domain and on my machine at work which is a member of a domain. Do you have sysadmin rights?...

I dont think you get the option to pick a file group. You could just create the structure of the table manually and put it where you need it, then...

We see a lot of the same problems even in pure Win environment. XP_Cmdshell is running under whatever you're using for the agent account. If that account does have disk...

Not much to be done except run dbcc, either with checktable or checkdb and set the repair options. I'd try to make a backup first just in case, entirely possible...

My recovery plan is to just snapshot everything and move on. Doesnt seem like its worth trying to salvage. Of course I have the luxury of a 100m switched network,...

Running SQL7 or SQL2K? Just curious.

One easy way is to break the publication up, either into one pub per table or into groups. Big tables by themselves, smaller tables in...

sp_oa~ is about my least favorite. Powerful idea, not so great implementation IMO. Let's see if anyone has ideas about other ways first, if not we'll try to get this...

Two logins IS easy...but you might have more later! Not worth the shortcut in my opinion. Restoring master is done very easily and quickly.

Definitely need the agent stopped. I would...

Hey Paul,

ASP a bit out of my element, but here is what I know...or think I know. Most ASP work is done using Server.whatever, meaning it happens on the IIS...

DTS packages that are saved on the server are contained in MSDB, a standard backup of it will capture them. If you're saving them to a .dts file then you...

Tried xp_stopmail/xp_startmail to see if anything changes? Do you get the same error when you try to test the mail from SQL agent? Using the same profile for SQL that...