I don't then you should even ask them about what to wear on the interview. Then it sounds as if you're trying to get out of dressing up - cutting...

What are you backing up ?   Is this SQL related ?

I'm using the SQL2005 Management Studio for my 2000 databases, but Scriptio is only for 2005 databases. Any other ideas for scripting out individual files ?  Currently, I go back...

I think your plan should work. That's basically what we did a few months ago.

But records at the publisher might change after the backup is taken but before the db is restored and replication is set up .... or am I missing something here...

I might be able to help with the SQL script if I had more details of what you actually want to do. I'm not the person to ask about VB....

Hmmmm    I suppose you could have a stored procedure that does the update, then VB script or something to execute the stored proc

I think you'll find the buttons up on the top of the EM bar, not in their old Win2000 location. It threw me for a little while.

Just wait 'till you try them in SQL 2005, they're even worse !

Just to add a simplified version ..........  When there are updates & writes, SQL logs that information in the transaction log. If you never backup the TLog, then SQL says...

ALTER DATABASE    MY_DB    COLLATE    SQL_Latin1_General_CP1_CI_AS

You mean the schedule area of the Maint plan is blank ?

In a maintenance plan, you have tabs for different options: Optimization, Integrity, Complete Backup and Transaction Log Backup. Each...

Transition to SQL2000 from what ?   And why is this in the "SQL Backup" forum ?

A little detail would be helpful .....         My car won't start, what's wrong with it ?

Here are my notes from when I encountered this. Perhaps you had the same problem as me in step 1 because the restored database was not a publisher ?

1)...