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
Solved

corrupt tempdb

Posted on 1999-01-08
11
717 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
  • 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
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
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 100 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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

829 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