?
Solved

-ve max. size ?

Posted on 1998-07-07
6
Medium Priority
?
195 Views
Last Modified: 2010-03-19
i want to expand the size of a database device, however, it doesn't work and i discovered that the max. size available is negative.  Do you know why?

Before that, an error has occurred. the message is :
Can't allocate space for object "Syslog" in database "Netstat" because the "logsegment" segment is full.

 
0
Comment
Question by:yyjulie
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 7

Expert Comment

by:spiridonov
ID: 1091672
first of all dump your transaction log and run
DBCC checktable syslogs command.
0
 

Author Comment

by:yyjulie
ID: 1091673
Already done but still cannot expand the size of database device.
0
 
LVL 7

Expert Comment

by:spiridonov
ID: 1091674
is it still giving you "logsegment full" messages ?
0
Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

 

Author Comment

by:yyjulie
ID: 1091675
Yes.
0
 
LVL 7

Expert Comment

by:spiridonov
ID: 1091676
Was the DUMP transaction  executed succesefully ? Have you run dbcc checktable syslogs ? if yes right-click on datavase in Sql Enterprise manager 'Server manager' window and choose edit -what does it show for log? Click on 'Truncate' and 'Recalculate'.
0
 
LVL 2

Accepted Solution

by:
Ezhil earned 20 total points
ID: 1091677
Instead of expanding the DB device , Add one more DB device your DB.

Double click your DB, click expand , In Data & log Device select <New> and add these devices to your DB.


0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question