Where Is Sp_help_revdatabase

Mar 22, 2000

where is sp_help_revdatabase - is there no script anymore which helps recreate the
database in the sad event that it is lost? I realize it would need mods for 7.0, but
there should be a 7.0 counterpart?

View 1 Replies

Sp_help_revdatabase In 7.0?

Dec 14, 1999

Does anyone know if there is an equivalent in 7.0 for 6.5's sp_help_revdatabase?

View 2 Replies View Related

Need Copy Of Sp_help_revdatabase Script

Jan 27, 2000

I've tried looking in Swynk.com without success. Can someone point me to where it is, or send it directly to me. Sounds like a great tool. Thanks.

View 1 Replies View Related

Sp_help_revdatabase / Tape Backups

Mar 3, 1999

I have a COTS database on MSSQL 6.5, no service packs...
I used sp_help_revdatabase to create the same database on a different server, using the same data and log device sizes and paths. I scripted the database, tables, stored procedures, and user defined datatypes, created them on the new server, and tried to restore a tape dump from the previous server to the new database. It would say "restoring", but then "DBLibrary is dead or connection broken", when I click OK to this message, it sais "restore complete" then the database appears grayed out and reads "loading".

View 1 Replies View Related