Group,
If i remember correct, when restoring an SQL 6.5 database file that had been
extended in size, you first had to re-create the database file on the same
chuck sizes and there also were a SQL command that showed the sizes of that
"chunks".
1. Is this correct or does my mind play with me?
2. What was this SQL command (stored procedure or?)
Regards /PeterYou have to get the same database fragment allocation (the sequence and size of allocation of
database and log fragments from devices). The allocations doesn't have to be from the same device as
it was originally, but the number, size and type (data or log)of allocations has to be the same. On
the source server, run sp_help_revdatabase.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Peter" <Peter.nospam@.news.com> wrote in message news:OYpMwlWxDHA.1704@.TK2MSFTNGP10.phx.gbl...
> Group,
> If i remember correct, when restoring an SQL 6.5 database file that had been
> extended in size, you first had to re-create the database file on the same
> chuck sizes and there also were a SQL command that showed the sizes of that
> "chunks".
> 1. Is this correct or does my mind play with me?
> 2. What was this SQL command (stored procedure or?)
> Regards /Peter
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment