Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-06-10 : 08:12:01
|
| Dave writes "Hello ChapsAfter updating a database on our SQL 7.0 running on Windows NT4 server I receive an error in Backup Exec 8.5, Invalid object name ‘databasename…sysfilegroups’I think that it is because a new data base has been formed but the old one is still some how there, I have tried deleting all the old database but the error is still there.I have seen that another chap had the same problem and asked the question on your site, I have check Backup Exec site but with no luck, I have also checked Microsoft site still no luck. Any idea about this error guys?Many ThanksDave " |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-10 : 13:07:50
|
| Why are you using Backup Exec? Why not use BACKUP DATABASE and BACKUP LOG to backup your databases?Tara |
 |
|
|
d.dangerous
Starting Member
1 Post |
Posted - 2004-06-14 : 03:51:59
|
| Tara thanks for the reply buy can you explain the backup thing further |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-06-14 : 08:09:50
|
| You should make a backup directory on the server and use BACKUP DATABASE to make backup files (.bak) nightly of your databases. You then use Backup Exec to back these files up to tape. It's much more dependable and easier to recover.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-16 : 12:29:33
|
quote:
Originally posted by d.dangerous
Tara thanks for the reply buy can you explain the backup thing further
What more would you like explained? Do you have SQL Server Client tools installed? If so, then you've got Books Online. The backup commands are explained in detail in there.Tara |
|
|
|
|
|
|
SQL 7 Invalid object name