Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

corrupt tempdb

Posted on 1999-01-08
11
Medium Priority
?
727 Views
Last Modified: 2006-11-17
Seagate Backup Exec. sometimes says the tempdb is corrupt. I expanded the size of tempdb. When I backup tempdb by itself its fine. When all the databases are backed up it sometimes gives a corrupt tempdb. What is causing this  and how do I insure my backups will not fail do to this prob.
0
Comment
Question by:cfinley
[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
  • 6
  • 4
11 Comments
 

Expert Comment

by:may11998
ID: 1092556
Why do you want to back up tempdb anyway, it is just a working database that your queries use?
0
 
LVL 9

Expert Comment

by:david_levine
ID: 1092557
There is no need to backup TEMPDB so don't bother. TEMPDB is re-built, so to speak each time SQL Server is started.

David
0
 

Author Comment

by:cfinley
ID: 1092558
I know the tempdb is temporary until the data dump or backup is performed. Just wanted to know why the tempdb would be seen as corrupt by seagate backup exec. What makes it corrupt one day and not the other. That was my question.
0
Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

 
LVL 9

Expert Comment

by:david_levine
ID: 1092559
First of all, when you back up using Seagate, is SQL Server shut down? If not, then you can't really back it up. You need to use the databases dump and load commands if the server is up. If the server is shut down, then you can use a normal file / volume backup and receovery strategy. What's the state of your server?


0
 

Author Comment

by:cfinley
ID: 1092560
The sql server is running. Just had that issue in the last two weeks . Don't know what corrupt means in Seagate terms. DBCC is performed on each database . I have excluded tempdb since your comment.
0
 
LVL 9

Expert Comment

by:david_levine
ID: 1092561
Ah! I have no idea while Seagate gives you an error, but it's not valid to do a file copy for any database file while the database server is up. You would never be guaranteed a valid backup.

If the server is running, use the servers dump command. If it isn't you can use Seagate.

If you want, contact Seagate, but I would imagine that would tell you the same thing and that you can't backup a file that's in use.

David
0
 

Author Comment

by:cfinley
ID: 1092562
If the file is in use it skips the file or database. All the dat and log files are skipped during the backup. I guess I won't worry about this since the nature of the temporary state of tempdb anyway. Just bothered me that is started recently and sometimes is sucessful and sometimes fails. What should I do now about this question? Thanks David for your time . What happens when I use all my points on questions. This was my first question in this exchange?
0
 
LVL 9

Expert Comment

by:david_levine
ID: 1092563
You have offered 100 points for this question. You get 200 when you start and 5 more points each day. So if you started when you posted the question, you probably have 110 or 115 points still. Should I post an answer to get points or do you think you should have your points given back to you? Let me know and I'll post an answer for you to accept if you want.

Good luck,
David
0
 

Author Comment

by:cfinley
ID: 1092564
Is it all 100 or can 50 points be the amount? Send me a posted answer and I will accept
0
 
LVL 9

Accepted Solution

by:
david_levine earned 300 total points
ID: 1092565
It shows you valued the question at 100 points.

David
0
 
LVL 9

Expert Comment

by:david_levine
ID: 1092566
BTW, the points don't matter much. I would answer your question if it only said 10 points. So don't really worry about how much you have.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

705 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