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!

alter database question

Status
Not open for further replies.

nyck

Technical User
Mar 10, 2004
447
GB
I have created a database and have added an addition log device, but when it finishes it comes back with an error. Do I need to worry about this:-

> use master
2> go
1> create database CONS_EUSK11_CUST on TSS125_Data2=400 log on TSS125_Log2=70
2> go
CREATE DATABASE: allocating 204800 logical pages (400.0 megabytes) on disk 'TSS125_Data2'.
CREATE DATABASE: allocating 35840 logical pages (70.0 megabytes) on disk 'TSS125_Log2'.
1> use master
2> go
1> alter database CONS_EUSK11_CUST log on TSS125_Log3=50
2> go
Extending database by 25600 pages (50.0 megabytes) on disk TSS125_Log3
Warning: Using ALTER DATABASE to extend the log segment will cause user thresholds on the log segment within 128 pages of the last chance threshold to be disabled.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top