Solved

corrupt tempdb

Posted on 1999-01-08
11
720 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
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
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

Backup Solution for AWS

Read about how CloudBerry Backup fully integrates your backups with Amazon S3 and Amazon Glacier to provide military-grade encryption and dramatically cut storage costs on any platform.

Question has a verified solution.

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

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

685 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