Solved

corrupt tempdb

Posted on 1999-01-08
11
711 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
 
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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server Deadlocks 12 49
SQL Server Question 5 25
T-SQL: Nested CASE Statements 4 24
Sql query 107 25
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
I have a large data set and a SSIS package. How can I load this file in multi threading?
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.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

911 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now