Good Morning,

Yes, I still have a 6.5 SQL database that I need to have becase of an old
version of Great Plains. The being said, I need to restore a very large
database. When I go to create the table to hold the database I get this
error: Error 5146: [SQL Server] The SIZE of 16777216 is out of range. It
must be between 512 and 16777215." If I make the database as large as I can
without getting the error, I either get an error when restoring the database
that it will not fit or the restore simply fails. It looks like the current
server that the backup was created on has two dat devices for the one
database but I don't know how to relate the two together.

Does anyone still remember 6.5 and if they do could they please help!

Thanks in advance.

Dale

Dale K (DaleK (AT) discussions (DOT) microsoft.com) writes:
Create table?

If memory serves, in SQL 6.5 when you wanted to restore a database, you
first had to create it. And you'd better have the output from
sp_help_revdatabase around to get the segment mapping right, or else
you would get data where the log was supposed to be and vice versa, and
it would go downhill from there. Although, you may be safe as long as you
only read.

I supposed the command that fails for you is CREATE DISK? Is that right?
CREATE TABLE does not sound right.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx