How To enlarge a Database

How To enlarge a Database

Post by Luis MIga » Sat, 12 Aug 2000 04:00:00



How can i change the size of the masterDB using a stored procedure?
Is there any SP in the system to do that???
 
 
 

How To enlarge a Database

Post by Neil Pik » Wed, 16 Aug 2000 04:00:00


 Luis,

 ALTER DATABASE ......

 > How can i change the size of the masterDB using a stored procedure?

Quote:> Is there any SP in the system to do that???

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 Reply here - no email
 SQL FAQ (484 entries) see
 forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps (faqrtf.zip - L7
- SQL Public)
 or    http://www.ntfaq.com/Section.cfm?sectionID=34
 or www.sqlserverfaq.com
 or www.mssqlserver.com/faq

 
 
 

1. How do I enlarge a database?

I've got a database called "nms", but when I tried:

        % isql -U sa -P ********
        1> alter database nms
        2> go

it gave me an error:

        Msg 5006, Level 16, State 1:
        Line 1:
        Could not find enough space on disks to extend database nms.

The problem is that there's more than 850 Megabytes free!

Am I missing something?


16203 WOODS                Send me a postcard, and I'll return another to you!
53150-8615 USA             Sendu al mi bildkarton, kaj mi redonos alian al vi!

2. sybase access from very remote location

3. How can I enlarge a database field?

4. Index question (best index structures for a table)

5. Enlarge database

6. 4th Annual JICST/NTIS Conference

7. any way to enlarge the # of processes?

8. INFORMIX PASSWORDs

9. How do I enlarge the 'logsegment'?

10. Burr 5a16d4441fc27 enlarged Madames grooms

11. Enlarging object on a layout

12. Enlarge Form

13. Q. Enlarge syslogs at master