Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 730
  • Last Modified:

corrupt tempdb

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
cfinley
Asked:
cfinley
  • 6
  • 4
1 Solution
 
may11998Commented:
Why do you want to back up tempdb anyway, it is just a working database that your queries use?
0
 
david_levineCommented:
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
 
cfinleyAuthor Commented:
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
david_levineCommented:
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
 
cfinleyAuthor Commented:
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
 
david_levineCommented:
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
 
cfinleyAuthor Commented:
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
 
david_levineCommented:
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
 
cfinleyAuthor Commented:
Is it all 100 or can 50 points be the amount? Send me a posted answer and I will accept
0
 
david_levineCommented:
It shows you valued the question at 100 points.

David
0
 
david_levineCommented:
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 6
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now