1. Yes, connect to the server as an administrator, issue the BACKUP DATABASE command in T-SQL.

2. No, any client will work, but you only get one connection. If you use...

Michael,

Thanks for that note. I had read that comment, and didn't get the point across in the editorial. The SAN guys deliberately put less disk behind the LUN. It definitely...

Keep the trigger small and tight to avoid performance stuff, and make sure you write the trigger for multiple rows. Don't set variables to values.

Not this:

...

select @pk = PKID from...

Gail has given a great explanation. There is no BEFORE trigger. The create trigger...for update is the same as the AFTER syntax.

Sorry, no, modify the data in a table.

If I have Customers:

Create table Customers( Customer varchar(20))

go

insert Customers select 'Acme'

union select 'Brad'

go

Now I want to change the Customer name to "Smith" and...

You guys are killing me. More work, then karate before I can even think about BBQ.

I saw Fat Red's on Memphis Beat. Is that a real place?

do what? stop jobs? just call sp_start_job. You can read about the parameters in Books Online. Same for sp_start_job.

You can schedule this to run, and here's a short discussion of...

If you modify a table, the trigger runs after the modification is done, but before it is committed.

George is correct in that each log file backup has different information. The log backup takes all active log records that are committed and copies them to thebackup.

There is no...

You can check the default trace for the information. If not too much time has passed, it should have the time in it.

http://www.sqlservercentral.com/articles/64547/

Otherwise, take the log backup, try restoring to...

If you are post SP2, there should be a checkbox to mark subfolders as existing for each database. Or are these not named for the databases?

You can create unique indexes on these fields, that do not need to be PKs or FKs.

The stopping/restarting could pontentially be done in T-SQL as well (Sp_start_job, sp_stop_job).

However be sure that if you re-run packages that they can restart themselves without issue and not do the...

I agree with bt if you can rewrite all code to use stored procs.

If you want to be 100% sure, or can't change code, use a trigger. Be sure you...