10-18-2017 9:22 PM - edited 02-04-2024 2:24 AM
1> load database DEV from "e:\QAS.DB"
2> go
Backup Server session id is: 9. Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server. Backup Server: 6.28.1.1: Dumpfile name 'QAS172900AFB8 ' section number 1 mounted on disk file 'e:\QAS.DB.asd' Msg 3105, Level 16, State 4: Server 'DEV', Line 1: Data on dump will not fit into current database. Need 507712 Mbyte database.
database approximately 500 GB
i should use this
disk resize name = "DEV_data_001", size = "507712M"
or
alter database DEV on DEV_data_001= "507712M"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If the database is already approximately 500GB, you only need to alter it by the difference between what is needed and the current size. (i.e. if the database is currently 500000M in size, you need only enlarge it by another 7712M).
If the device doesn't have that much free space, you would need to first either
a) resize the device by at least the amount of extra space needed or
b) alter onto a different device that has enough free space or
c) disk init a new device and alter onto the new device
Typically this message means exactly what it says, you need to create a database at least as large as the message
indicates in order to load the dump.
How big is the database currently?
-bret
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.