Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pramod21
Yak Posting Veteran
64 Posts |
 Posted - 2012-08-09 : 02:21:03
|
| Hi All,I was importing database from one database server to another in cloud, but after importing 30 databases it gives an error that, " Database creation would exceed quota of 30 The transaction ended in the trigger. The batch has been aborted. (Microsoft sql server error: 50000)"Plz let me know is there any setting or way where i can increase the limit of no of databases. Or is there any other solution.Thanks. |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-08-09 : 06:35:38
|
| Depends what yoou are usoing - it will be a limitation on that server which could be host specific.Azure has a default of 150 (or 149).You might consider reducing the number of databases maybe using schemas instead.Also need to look at all the limitations on that server to see if anything might impact you - like max size of a database or total storage.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
|
|
pramod21
Yak Posting Veteran
64 Posts |
Posted - 2012-08-09 : 06:45:18
|
| its amazon RDS..thanks for reply.. |
|
|
|
pramod21
Yak Posting Veteran
64 Posts |
Posted - 2012-08-09 : 08:22:01
|
| Hi,I'm not able to alter or delete the trigger on RDS.can u plz help me out to overcome on this problem..??Thanks |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-08-09 : 11:22:35
|
| Combine databases I guess. I suspect it is a limitation of the product supplied.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Import database