The procedure can be found here...

http://www.sqlservercentral.com/scripts/Index+Management/31475/

By the way, this has not been tested by me on anything more recent than SQL 2000.

Steve

Trimel,

Great suggestion!  I don't think I tried that.  Unfortunately, this post was from 2 years ago.  I think I ended up recreating the database.  Now, the database is no longer...

Does the id that runs the job have rights to the share?

I'd be willing to bet that you're looking at the wrong disk.  If you've developed the DTS package on your local machine and specified the path as "X:\my_folder\my_file.txt", and it...

Sorry that I haven't responded.  I've not been able to spend any time here lately.  Remi has it.  Indid 255 is an entry for tables that have text or image...

Have you checked for bad data?  Not sure what you are converting with your "CONVERT" function, but if its reading an invalid date, that'd do it.

Steve

DarylAndDaryl,

Sent you a private message regarding scripts.

Steve

When you select "restore database", the filenames of the backups should be listed in the selection box.  Otherwise, to ensure that you are not overwriting when using the wizard, change...

My recommendation would be to use tSQL in Query Analyzer.  Locate your backup file and then use the following syntax -

This statement will give you the logical filenames for the...

My suggestion is to either ignore it or take out the PRINT statement.  It doesn't hurt anything.  Your job functions the same with or without it.  Its just an informational...

If SQL Agent successfully calls the command shell, well, it considers it a success regardless of what happens in that shell.

To accomplish what you are trying to do, create an...

I'm with Darrell.  I don't even have an OLD laptop to replace!  Hey!  Whaddya doin' with your old one??????

Steve

Arnold,

I've never tried it, so I can't say that it definitely won't work, but... It is my sincere opinion that you cannot restore a master database from a Standard Edition...

Its caused by your join to the backupfile table, which is sending you 1 row for every database file (mdf) and 1 row for every transaction log file (ldf), instead...

Yelena,

I started to mention a little earlier that I have a stored procedure that will copy the login, password (encrypted), and SID and create a script that you can cut...