Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MAXSIZE won't change?

Status
Not open for further replies.

ptheriault

IS-IT--Management
Aug 28, 2006
2,699
US
SQL Server 2005 64 Bit Enterprise Edition.

When I run the the following command I get command completed successfully.

Code:
ALTER DATABASE Apollo_Replication
MODIFY FILE (NAME = Apollo_Replication_log,
MAXSIZE = 'UNLIMITED')

However when I look at the database properties the file growth is still restricted to 2 GB. I even tried to edit the property through SSMS. Same results...It looks like it saves ok but when I go back in... no change.
The only thing unique about the db is it is the subscriber from an Oracle publisher.
Has anyone seen this little feature before?


- Paul
- If at first you don't succeed, find out if the loser gets anything.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top