Missing dll file: backup

Showing posts with label backup. Show all posts

Monday, March 26, 2012

Model backup failed

Good morning,
I am new to sql server and I have an issue with my backups.
So I set up these jobs:
Backup for System database:
Model, Master, MSDB DATABASE separately (every day at 22h)
Model, Master, MSDB log separately (every hour, between 5h-21h)
Backup for User Database
Database User (every day at 23h)
Database Log (every hour, between 02h-21h)
2 Plan Maintenance
Integrity Checks for all Database (System + User)
Optimization Job for all Database (System + User)
Why does my model backup and msdb log failed ? any idea?
Thanks
InaCan you post us the contents of your error log file please!
"ina" <roberta.inalbon@.gmail.com> wrote in message
news:1155022867.432337.303640@.75g2000cwc.googlegroups.com...
> Good morning,
> I am new to sql server and I have an issue with my backups.
> So I set up these jobs:
> Backup for System database:
> Model, Master, MSDB DATABASE separately (every day at 22h)
> Model, Master, MSDB log separately (every hour, between 5h-21h)
> Backup for User Database
> Database User (every day at 23h)
> Database Log (every hour, between 02h-21h)
> 2 Plan Maintenance
> Integrity Checks for all Database (System + User)
> Optimization Job for all Database (System + User)
> Why does my model backup and msdb log failed ? any idea?
> Thanks
> Ina
>|||Immy wrote:
> Can you post us the contents of your error log file please!
> "ina" <roberta.inalbon@.gmail.com> wrote in message
> news:1155022867.432337.303640@.75g2000cwc.googlegroups.com...
> > Good morning,
> >
> > I am new to sql server and I have an issue with my backups.
> >
> > So I set up these jobs:
> >
> > Backup for System database:
> >
> > Model, Master, MSDB DATABASE separately (every day at 22h)
> > Model, Master, MSDB log separately (every hour, between 5h-21h)
> >
> > Backup for User Database
> >
> > Database User (every day at 23h)
> > Database Log (every hour, between 02h-21h)
> >
> > 2 Plan Maintenance
> > Integrity Checks for all Database (System + User)
> > Optimization Job for all Database (System + User)
> >
> > Why does my model backup and msdb log failed ? any idea?
> >
> > Thanks
> >
> > Ina
> >
What is recovery model msdb database? If it is simple you log backup
will fail
For model database backup failure look in error log , it will have
detailed information about it.
Regards
Amish Shah|||"ina" <roberta.inalbon@.gmail.com> wrote in message
news:1155022867.432337.303640@.75g2000cwc.googlegroups.com...
> Good morning,
> I am new to sql server and I have an issue with my backups.
> So I set up these jobs:
> Backup for System database:
> Model, Master, MSDB DATABASE separately (every day at 22h)
> Model, Master, MSDB log separately (every hour, between 5h-21h)
> Backup for User Database
> Database User (every day at 23h)
> Database Log (every hour, between 02h-21h)
> 2 Plan Maintenance
> Integrity Checks for all Database (System + User)
> Optimization Job for all Database (System + User)
> Why does my model backup and msdb log failed ? any idea?
Beacuse they are in SIMPLE recovery mode and there's no need for a
logbackup.
The full should work fine though.
> Thanks
> Ina
>|||Hi,
What is the error you are getting?
First of all there is no need to backup the log for Model and Master
database; this is because we
are not supposed to do manipulations into these system databases.
Incase if you are getting errors in transaction log backup then verify the
recovery model for MSDB and Model databases.
For transaction log backup the recovery model should be either Bulk_logged
or Full.
Thanks
Hari
SQL Server MVP
"ina" <roberta.inalbon@.gmail.com> wrote in message
news:1155022867.432337.303640@.75g2000cwc.googlegroups.com...
> Good morning,
> I am new to sql server and I have an issue with my backups.
> So I set up these jobs:
> Backup for System database:
> Model, Master, MSDB DATABASE separately (every day at 22h)
> Model, Master, MSDB log separately (every hour, between 5h-21h)
> Backup for User Database
> Database User (every day at 23h)
> Database Log (every hour, between 02h-21h)
> 2 Plan Maintenance
> Integrity Checks for all Database (System + User)
> Optimization Job for all Database (System + User)
> Why does my model backup and msdb log failed ? any idea?
> Thanks
> Ina
>|||Thanks guys.
It was because the MSDB Database was set up to simple instead of Full.
I changed it
but the model DB backup I do not know why it is failing
The job failed. The Job was invoked by Schedule 26 (Schedule 1). The
last step to run was step 1 (Step 1).
This is the job error I get.
Ina
I thing
Hari Prasad wrote:
> Hi,
> What is the error you are getting?
> First of all there is no need to backup the log for Model and Master
> database; this is because we
> are not supposed to do manipulations into these system databases.
> Incase if you are getting errors in transaction log backup then verify the
> recovery model for MSDB and Model databases.
> For transaction log backup the recovery model should be either Bulk_logged
> or Full.
> Thanks
> Hari
> SQL Server MVP
>
> "ina" <roberta.inalbon@.gmail.com> wrote in message
> news:1155022867.432337.303640@.75g2000cwc.googlegroups.com...
> > Good morning,
> >
> > I am new to sql server and I have an issue with my backups.
> >
> > So I set up these jobs:
> >
> > Backup for System database:
> >
> > Model, Master, MSDB DATABASE separately (every day at 22h)
> > Model, Master, MSDB log separately (every hour, between 5h-21h)
> >
> > Backup for User Database
> >
> > Database User (every day at 23h)
> > Database Log (every hour, between 02h-21h)
> >
> > 2 Plan Maintenance
> > Integrity Checks for all Database (System + User)
> > Optimization Job for all Database (System + User)
> >
> > Why does my model backup and msdb log failed ? any idea?
> >
> > Thanks
> >
> > Ina
> >|||Specify a report file for the Maint Plan and check for the SQL Server errors in that report file.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"ina" <roberta.inalbon@.gmail.com> wrote in message
news:1155043376.504435.46880@.n13g2000cwa.googlegroups.com...
> Thanks guys.
> It was because the MSDB Database was set up to simple instead of Full.
> I changed it
> but the model DB backup I do not know why it is failing
> The job failed. The Job was invoked by Schedule 26 (Schedule 1). The
> last step to run was step 1 (Step 1).
> This is the job error I get.
> Ina
> I thing
> Hari Prasad wrote:
>> Hi,
>> What is the error you are getting?
>> First of all there is no need to backup the log for Model and Master
>> database; this is because we
>> are not supposed to do manipulations into these system databases.
>> Incase if you are getting errors in transaction log backup then verify the
>> recovery model for MSDB and Model databases.
>> For transaction log backup the recovery model should be either Bulk_logged
>> or Full.
>> Thanks
>> Hari
>> SQL Server MVP
>>
>> "ina" <roberta.inalbon@.gmail.com> wrote in message
>> news:1155022867.432337.303640@.75g2000cwc.googlegroups.com...
>> > Good morning,
>> >
>> > I am new to sql server and I have an issue with my backups.
>> >
>> > So I set up these jobs:
>> >
>> > Backup for System database:
>> >
>> > Model, Master, MSDB DATABASE separately (every day at 22h)
>> > Model, Master, MSDB log separately (every hour, between 5h-21h)
>> >
>> > Backup for User Database
>> >
>> > Database User (every day at 23h)
>> > Database Log (every hour, between 02h-21h)
>> >
>> > 2 Plan Maintenance
>> > Integrity Checks for all Database (System + User)
>> > Optimization Job for all Database (System + User)
>> >
>> > Why does my model backup and msdb log failed ? any idea?
>> >
>> > Thanks
>> >
>> > Ina
>> >
>|||Thank you all for this good advice I will check it.
Ina
Tibor Karaszi wrote:
> Specify a report file for the Maint Plan and check for the SQL Server errors in that report file.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "ina" <roberta.inalbon@.gmail.com> wrote in message
> news:1155043376.504435.46880@.n13g2000cwa.googlegroups.com...
> > Thanks guys.
> >
> > It was because the MSDB Database was set up to simple instead of Full.
> > I changed it
> > but the model DB backup I do not know why it is failing
> >
> > The job failed. The Job was invoked by Schedule 26 (Schedule 1). The
> > last step to run was step 1 (Step 1).
> >
> > This is the job error I get.
> >
> > Ina
> >
> > I thing
> > Hari Prasad wrote:
> >> Hi,
> >>
> >> What is the error you are getting?
> >>
> >> First of all there is no need to backup the log for Model and Master
> >> database; this is because we
> >> are not supposed to do manipulations into these system databases.
> >>
> >> Incase if you are getting errors in transaction log backup then verify the
> >> recovery model for MSDB and Model databases.
> >> For transaction log backup the recovery model should be either Bulk_logged
> >> or Full.
> >>
> >> Thanks
> >> Hari
> >> SQL Server MVP
> >>
> >>
> >> "ina" <roberta.inalbon@.gmail.com> wrote in message
> >> news:1155022867.432337.303640@.75g2000cwc.googlegroups.com...
> >> > Good morning,
> >> >
> >> > I am new to sql server and I have an issue with my backups.
> >> >
> >> > So I set up these jobs:
> >> >
> >> > Backup for System database:
> >> >
> >> > Model, Master, MSDB DATABASE separately (every day at 22h)
> >> > Model, Master, MSDB log separately (every hour, between 5h-21h)
> >> >
> >> > Backup for User Database
> >> >
> >> > Database User (every day at 23h)
> >> > Database Log (every hour, between 02h-21h)
> >> >
> >> > 2 Plan Maintenance
> >> > Integrity Checks for all Database (System + User)
> >> > Optimization Job for all Database (System + User)
> >> >
> >> > Why does my model backup and msdb log failed ? any idea?
> >> >
> >> > Thanks
> >> >
> >> > Ina
> >> >
> >

Model backup failed

Monday, March 19, 2012

Misunderstanding of backup

I always assumed that the backup & restore procedure stored simply
data, not structure.

Now I find that if I add a new table to a database, then restore using
an old backup, the new table is gone.

Is there any way to restore JUST the data from a backup? If not, is
there any way to archive & import just data? The import/export wizard
only seems to send a single table to a flat file, but I need all the
tables.

Is there perhaps a command-line parameterthat isn't available in the
wizard that would accomplish this?You can restore to a different database or server and then copy over
the data.
http://msdn.microsoft.com/library/d...backpc_6ng9.asp

--
David Portas
SQL Server MVP
--|||You can restore to a different database or server and then copy over
the data.
http://msdn.microsoft.com/library/d...backpc_6ng9.asp

--
David Portas
SQL Server MVP
--|||
David Portas wrote:
> You can restore to a different database or server and then copy over
> the data.
> http://msdn.microsoft.com/library/d...backpc_6ng9.asp
> --
> David Portas
> SQL Server MVP
> --

Must the data be copied using the MOVE command, or can I simply
physically relocate the ldf & mdf files to the target server?|||
David Portas wrote:
> You can restore to a different database or server and then copy over
> the data.
> http://msdn.microsoft.com/library/d...backpc_6ng9.asp
> --
> David Portas
> SQL Server MVP
> --

Must the data be copied using the MOVE command, or can I simply
physically relocate the ldf & mdf files to the target server?|||You can always detach and reattach the files (sp_attach_db and sp_detach_db)
but as you'll have to restore them first you may as well restore them where
you want them to start with.

--
David Portas
SQL Server MVP
--|||You can always detach and reattach the files (sp_attach_db and sp_detach_db)
but as you'll have to restore them first you may as well restore them where
you want them to start with.

--
David Portas
SQL Server MVP
--|||
David Portas wrote:
> You can always detach and reattach the files (sp_attach_db and sp_detach_db)
> but as you'll have to restore them first you may as well restore them where
> you want them to start with.
> --
> David Portas
> SQL Server MVP
> --

Once the new temp database is created, what procedure would you
recommend for copying just the data between databases?|||Darryl (DarrylJ@.yahoo.com) writes:
> David Portas wrote:
>> You can always detach and reattach the files (sp_attach_db and
>> sp_detach_db) but as you'll have to restore them first you may as well
>> restore them where you want them to start with.
>>
> Once the new temp database is created, what procedure would you
> recommend for copying just the data between databases?

Depends on why, and how often etc. If you want to do it on a regular
basis, replication could be the way to go. For a one-off thing,
it depends on whether the target database already has data, and
what you want to do with it etc.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Mistakenly dropped database in SQL Server! Data recovery?

Could anyone please help with any ideas?
A database was mistakenly dropped in SQL Server. There were no backup files
. Nothing else has been written to the hard drive so the data should still
be on the hard drive (not overwritten). Can anyone help or offer any ideas
as to how I might be able t
o recover this? Is there data recovery software that will look at the hardd
rive to find and restore this data (similar to a recycle bin restore?) Any
assistance would be greatly appreciated as soon as possible. I would be ve
ry grateful for any ideas/s
uggestions.search on google for undelete or unerase softwares, there are plenty of them
available.
but they will work only till nothing else overrites on the disk.
And its always good to have backups of important databases.
regards,
harshal.
"Steve" <anonymous@.discussions.microsoft.com> wrote in message
news:404D6405-6AD1-48CB-BC01-5CEC9A87DD1A@.microsoft.com...
> Could anyone please help with any ideas?
> A database was mistakenly dropped in SQL Server. There were no backup
files. Nothing else has been written to the hard drive so the data should
still be on the hard drive (not overwritten). Can anyone help or offer any
ideas as to how I might be able to recover this? Is there data recovery
software that will look at the harddrive to find and restore this data
(similar to a recycle bin restore?) Any assistance would be greatly
appreciated as soon as possible. I would be very grateful for any
ideas/suggestions.

Mistakenly dropped database in SQL Server! Data recovery?

Could anyone please help with any ideas?
A database was mistakenly dropped in SQL Server. There were no backup files. Nothing else has been written to the hard drive so the data should still be on the hard drive (not overwritten). Can anyone help or offer any ideas as to how I might be able to recover this? Is there data recovery software that will look at the harddrive to find and restore this data (similar to a recycle bin restore?) Any assistance would be greatly appreciated as soon as possible. I would be very grateful for any ideas/suggestions.search on google for undelete or unerase softwares, there are plenty of them
available.
but they will work only till nothing else overrites on the disk.
And its always good to have backups of important databases.
regards,
harshal.
"Steve" <anonymous@.discussions.microsoft.com> wrote in message
news:404D6405-6AD1-48CB-BC01-5CEC9A87DD1A@.microsoft.com...
> Could anyone please help with any ideas?
> A database was mistakenly dropped in SQL Server. There were no backup
files. Nothing else has been written to the hard drive so the data should
still be on the hard drive (not overwritten). Can anyone help or offer any
ideas as to how I might be able to recover this? Is there data recovery
software that will look at the harddrive to find and restore this data
(similar to a recycle bin restore?) Any assistance would be greatly
appreciated as soon as possible. I would be very grateful for any
ideas/suggestions.

Monday, March 12, 2012

missing tables and stored procedures after restoring database

Thank you for your assistance.
"Mike Hodgson" wrote:
[vbcol=seagreen]
> If they're missing after a restore then they were not there at the time
> of the back and are now gone forever (presumedly they were created after
> the backup you used to restore the DB). Do you have any later backups?
> BTW, every table & proc in a DB has an owner. To be sure you're just
> not missing it in whatever client-side tool you're using execute this T-SQL:
> select o.[name] as tablename, u.[name] as ownername, type
> from dbo.sysobjects as o
> inner join dbo.sysusers as u on o.uid = o.uid
> order by type, u.[name], o.[name]
> Have a look to see if you can see the proc (type P) or the table (type
> U) somewhere in the resultset. Also are you sure these "vital" tables &
> procs were in the same database and weren't in another database that was
> being referenced from your database? For example,
> use A
> go
> select * from B.dbo.MyVitalTable
> exec B.dbo.MyVitalProc
> If that was true then they wouldn't be included in the backup (and
> therefore subsequent restore) of your database.
> --
> *mike hodgson*
> blog: http://sqlnerd.blogspot.com
>
> Old Paulie wrote:
|||One last chance. Perhaps your backup file has several backups on it, and you restore the first one?
Check using RESTORE HEADERONLY.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Old Paulie" <OldPaulie@.discussions.microsoft.com> wrote in message
news:BADA21C1-5F74-4E9A-83FD-779132C78585@.microsoft.com...[vbcol=seagreen]
> Hi Mike,
> I am quite sure that the vital tables belonged to my database as I had
> created no others! I did run your query and did not find and records
> relating to the missing tables and stored procedures. From your advice and
> 'saradhi's', it is obvious now that my backup was flawed and I am doing
> something wrong

Thank you for your assistance.
> "Mike Hodgson" wrote:
|||Tibor,
It turns out that my backup DID include several backup sets and I was
therefore able to restore the most recent backup set to get back all missing
tables and procedures.
THANK YOU VERY MUCH!
"Tibor Karaszi" wrote:

> One last chance. Perhaps your backup file has several backups on it, and you restore the first one?
> Check using RESTORE HEADERONLY.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Old Paulie" <OldPaulie@.discussions.microsoft.com> wrote in message
> news:BADA21C1-5F74-4E9A-83FD-779132C78585@.microsoft.com...
>

missing tables and stored procedures after restoring database

Thank you for your assistance.
"Mike Hodgson" wrote:
[vbcol=seagreen]
> If they're missing after a restore then they were not there at the time
> of the back and are now gone forever (presumedly they were created after
> the backup you used to restore the DB). Do you have any later backups?
> BTW, every table & proc in a DB has an owner. To be sure you're just
> not missing it in whatever client-side tool you're using execute this T-SQ
L:
> select o.[name] as tablename, u.[name] as ownername, type
> from dbo.sysobjects as o
> inner join dbo.sysusers as u on o.uid = o.uid
> order by type, u.[name], o.[name]
> Have a look to see if you can see the proc (type P) or the table (type
> U) somewhere in the resultset. Also are you sure these "vital" tables &
> procs were in the same database and weren't in another database that was
> being referenced from your database? For example,
> use A
> go
> select * from B.dbo.MyVitalTable
> exec B.dbo.MyVitalProc
> If that was true then they wouldn't be included in the backup (and
> therefore subsequent restore) of your database.
> --
> *mike hodgson*
> blog: http://sqlnerd.blogspot.com
>
> Old Paulie wrote:
>|||One last chance. Perhaps your backup file has several backups on it, and you
restore the first one?
Check using RESTORE HEADERONLY.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Old Paulie" <OldPaulie@.discussions.microsoft.com> wrote in message
news:BADA21C1-5F74-4E9A-83FD-779132C78585@.microsoft.com...[vbcol=seagreen]
> Hi Mike,
> I am quite sure that the vital tables belonged to my database as I had
> created no others! I did run your query and did not find and records
> relating to the missing tables and stored procedures. From your advice an
d
> 'saradhi's', it is obvious now that my backup was flawed and I am doing
> something wrong

Thank you for your assistance.
> "Mike Hodgson" wrote:
>|||Tibor,
It turns out that my backup DID include several backup sets and I was
therefore able to restore the most recent backup set to get back all missing
tables and procedures.
THANK YOU VERY MUCH!
"Tibor Karaszi" wrote:

> One last chance. Perhaps your backup file has several backups on it, and y
ou restore the first one?
> Check using RESTORE HEADERONLY.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Old Paulie" <OldPaulie@.discussions.microsoft.com> wrote in message
> news:BADA21C1-5F74-4E9A-83FD-779132C78585@.microsoft.com...
>

missing tables and stored procedures after restoring database

I have been running a desktop PC with MSDE 1.0 installed. I had made a
backup of the data using a t-sql command backup database ... Since this PC
had crashed and has subsequently been rebuilt, I have restored the database
but found that vital tables and stored procedures are missing. The missing
tables were not allegedly owned by dbo but perhaps had no owner(?) PS I log
into the database as user sa.
Any help in recovering those missing tables and stored procedures would be
greatly appreciated.use restore headeronly command on the backup file To check when the
backup was taken looks like you haven't backed up the database when
you created the tables whcih you said you were missing or you have
restored
an earlier backup not the latest once since you are the Sysadmin u can
view all the tables created with any login and if you want to have
information
about the latest backup taken check out the one with
Use Msdb
select *from backupset
order by backup_finish_date desc|||This is a multi-part message in MIME format.
--080807080807040609090709
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
If they're missing after a restore then they were not there at the time
of the back and are now gone forever (presumedly they were created after
the backup you used to restore the DB). Do you have any later backups?
BTW, every table & proc in a DB has an owner. To be sure you're just
not missing it in whatever client-side tool you're using execute this T-SQL:
select o.[name] as tablename, u.[name] as ownername, type
from dbo.sysobjects as o
inner join dbo.sysusers as u on o.uid = o.uid
order by type, u.[name], o.[name]
Have a look to see if you can see the proc (type P) or the table (type
U) somewhere in the resultset. Also are you sure these "vital" tables &
procs were in the same database and weren't in another database that was
being referenced from your database? For example,
use A
go
select * from B.dbo.MyVitalTable
exec B.dbo.MyVitalProc
If that was true then they wouldn't be included in the backup (and
therefore subsequent restore) of your database.
--
*mike hodgson*
blog: http://sqlnerd.blogspot.com
Old Paulie wrote:
>I have been running a desktop PC with MSDE 1.0 installed. I had made a
>backup of the data using a t-sql command backup database ... Since this PC
>had crashed and has subsequently been rebuilt, I have restored the database
>but found that vital tables and stored procedures are missing. The missing
>tables were not allegedly owned by dbo but perhaps had no owner(?) PS I log
>into the database as user sa.
>Any help in recovering those missing tables and stored procedures would be
>greatly appreciated.
>
--080807080807040609090709
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>If they're missing after a restore then they were not there at the
time of the back and are now gone forever (presumedly they were created
after the backup you used to restore the DB).Â Do you have any later
backups? 
 
BTW, every table & proc in a DB has an owner.Â To be sure you're
just not missing it in whatever client-side tool you're using execute
this T-SQL: 
</tt>
<blockquote><tt>select o.[name] as tablename, u.[name] as ownername,
type 
from dbo.sysobjects as o 
Â Â Â inner join dbo.sysusers as u on o.uid = o.uid 
order by type, u.[name], o.[name] 
</tt></blockquote>
<tt>Have a look to see if you can see the proc (type P) or the table
(type U) somewhere in the resultset.Â Also are you sure these "vital"
tables & procs were in the same database and weren't in another
database that was being referenced from your database?Â For example, 
</tt>
<blockquote><tt>use A 
go 
 
select * from B.dbo.MyVitalTable 
exec B.dbo.MyVitalProc 
</tt></blockquote>
<tt>If that was true then they wouldn't be included in the backup (and
therefore subsequent restore) of your database.</tt> 
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
-- 
 mike
hodgson 
blog: <a
href="http://links.10026.com/?link=http://sqlnerd.blogspot.com</a>">http://sqlnerd.blogspot.com">http://sqlnerd.blogspot.com</a>

</div>
 
 
Old Paulie wrote:
<blockquote cite="mid99FCEEAA-D592-4D73-AD2D-946AD7C71952@.microsoft.com"
type="cite">
<pre wrap="">I have been running a desktop PC with MSDE 1.0 installed. I had made a
backup of the data using a t-sql command backup database ... Since this PC
had crashed and has subsequently been rebuilt, I have restored the database
but found that vital tables and stored procedures are missing. The missing
tables were not allegedly owned by dbo but perhaps had no owner(?) PS I log
into the database as user sa.
Any help in recovering those missing tables and stored procedures would be
greatly appreciated.
</pre>
</blockquote>
</body>
</html>
--080807080807040609090709--|||saradhi,
Thanks for the advice, I have checked the backupset table in the Msdb
database and that only describes one backup taken last year. The backup at
that time probably would not have included these missing tables. I had
however made several backups and their is no proof of these in this table. I
need to obviously review the way I back up since it appears I am doing
something fundamentally wrong. Any advice on backing up for future reference
would be greatly appreciated. Should I be backing up the other databases
that are created upon install of msde, ie Master, Msdb etc ...?
"saradhi" wrote:
> use restore headeronly command on the backup file To check when the
> backup was taken looks like you haven't backed up the database when
> you created the tables whcih you said you were missing or you have
> restored
> an earlier backup not the latest once since you are the Sysadmin u can
> view all the tables created with any login and if you want to have
> information
> about the latest backup taken check out the one with
> Use Msdb
> select *from backupset
> order by backup_finish_date desc
>|||Hi Mike,
I am quite sure that the vital tables belonged to my database as I had
created no others! I did run your query and did not find and records
relating to the missing tables and stored procedures. From your advice and
'saradhi's', it is obvious now that my backup was flawed and I am doing
something wrong:( Thank you for your assistance.
"Mike Hodgson" wrote:
> If they're missing after a restore then they were not there at the time
> of the back and are now gone forever (presumedly they were created after
> the backup you used to restore the DB). Do you have any later backups?
> BTW, every table & proc in a DB has an owner. To be sure you're just
> not missing it in whatever client-side tool you're using execute this T-SQL:
> select o.[name] as tablename, u.[name] as ownername, type
> from dbo.sysobjects as o
> inner join dbo.sysusers as u on o.uid = o.uid
> order by type, u.[name], o.[name]
> Have a look to see if you can see the proc (type P) or the table (type
> U) somewhere in the resultset. Also are you sure these "vital" tables &
> procs were in the same database and weren't in another database that was
> being referenced from your database? For example,
> use A
> go
> select * from B.dbo.MyVitalTable
> exec B.dbo.MyVitalProc
> If that was true then they wouldn't be included in the backup (and
> therefore subsequent restore) of your database.
> --
> *mike hodgson*
> blog: http://sqlnerd.blogspot.com
>
> Old Paulie wrote:
> >I have been running a desktop PC with MSDE 1.0 installed. I had made a
> >backup of the data using a t-sql command backup database ... Since this PC
> >had crashed and has subsequently been rebuilt, I have restored the database
> >but found that vital tables and stored procedures are missing. The missing
> >tables were not allegedly owned by dbo but perhaps had no owner(?) PS I log
> >into the database as user sa.
> >
> >Any help in recovering those missing tables and stored procedures would be
> >greatly appreciated|||One last chance. Perhaps your backup file has several backups on it, and you restore the first one?
Check using RESTORE HEADERONLY.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Old Paulie" <OldPaulie@.discussions.microsoft.com> wrote in message
news:BADA21C1-5F74-4E9A-83FD-779132C78585@.microsoft.com...
> Hi Mike,
> I am quite sure that the vital tables belonged to my database as I had
> created no others! I did run your query and did not find and records
> relating to the missing tables and stored procedures. From your advice and
> 'saradhi's', it is obvious now that my backup was flawed and I am doing
> something wrong:( Thank you for your assistance.
> "Mike Hodgson" wrote:
>> If they're missing after a restore then they were not there at the time
>> of the back and are now gone forever (presumedly they were created after
>> the backup you used to restore the DB). Do you have any later backups?
>> BTW, every table & proc in a DB has an owner. To be sure you're just
>> not missing it in whatever client-side tool you're using execute this T-SQL:
>> select o.[name] as tablename, u.[name] as ownername, type
>> from dbo.sysobjects as o
>> inner join dbo.sysusers as u on o.uid = o.uid
>> order by type, u.[name], o.[name]
>> Have a look to see if you can see the proc (type P) or the table (type
>> U) somewhere in the resultset. Also are you sure these "vital" tables &
>> procs were in the same database and weren't in another database that was
>> being referenced from your database? For example,
>> use A
>> go
>> select * from B.dbo.MyVitalTable
>> exec B.dbo.MyVitalProc
>> If that was true then they wouldn't be included in the backup (and
>> therefore subsequent restore) of your database.
>> --
>> *mike hodgson*
>> blog: http://sqlnerd.blogspot.com
>>
>> Old Paulie wrote:
>> >I have been running a desktop PC with MSDE 1.0 installed. I had made a
>> >backup of the data using a t-sql command backup database ... Since this PC
>> >had crashed and has subsequently been rebuilt, I have restored the database
>> >but found that vital tables and stored procedures are missing. The missing
>> >tables were not allegedly owned by dbo but perhaps had no owner(?) PS I log
>> >into the database as user sa.
>> >
>> >Any help in recovering those missing tables and stored procedures would be
>> >greatly appreciated|||Tibor,
It turns out that my backup DID include several backup sets and I was
therefore able to restore the most recent backup set to get back all missing
tables and procedures.
THANK YOU VERY MUCH!
"Tibor Karaszi" wrote:
> One last chance. Perhaps your backup file has several backups on it, and you restore the first one?
> Check using RESTORE HEADERONLY.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Old Paulie" <OldPaulie@.discussions.microsoft.com> wrote in message
> news:BADA21C1-5F74-4E9A-83FD-779132C78585@.microsoft.com...
> > Hi Mike,
> >
> > I am quite sure that the vital tables belonged to my database as I had
> > created no others! I did run your query and did not find and records
> > relating to the missing tables and stored procedures. From your advice and
> > 'saradhi's', it is obvious now that my backup was flawed and I am doing
> > something wrong:( Thank you for your assistance.
> >
> > "Mike Hodgson" wrote:
> >
> >> If they're missing after a restore then they were not there at the time
> >> of the back and are now gone forever (presumedly they were created after
> >> the backup you used to restore the DB). Do you have any later backups?
> >>
> >> BTW, every table & proc in a DB has an owner. To be sure you're just
> >> not missing it in whatever client-side tool you're using execute this T-SQL:
> >>
> >> select o.[name] as tablename, u.[name] as ownername, type
> >> from dbo.sysobjects as o
> >> inner join dbo.sysusers as u on o.uid = o.uid
> >> order by type, u.[name], o.[name]
> >>
> >> Have a look to see if you can see the proc (type P) or the table (type
> >> U) somewhere in the resultset. Also are you sure these "vital" tables &
> >> procs were in the same database and weren't in another database that was
> >> being referenced from your database? For example,
> >>
> >> use A
> >> go
> >>
> >> select * from B.dbo.MyVitalTable
> >> exec B.dbo.MyVitalProc
> >>
> >> If that was true then they wouldn't be included in the backup (and
> >> therefore subsequent restore) of your database.
> >>
> >> --
> >> *mike hodgson*
> >> blog: http://sqlnerd.blogspot.com
> >>
> >>
> >>
> >> Old Paulie wrote:
> >>
> >> >I have been running a desktop PC with MSDE 1.0 installed. I had made a
> >> >backup of the data using a t-sql command backup database ... Since this PC
> >> >had crashed and has subsequently been rebuilt, I have restored the database
> >> >but found that vital tables and stored procedures are missing. The missing
> >> >tables were not allegedly owned by dbo but perhaps had no owner(?) PS I log
> >> >into the database as user sa.
> >> >
> >> >Any help in recovering those missing tables and stored procedures would be
> >> >greatly appreciated
>

Missing sysjobhistory in sql job

Hi,
I have a sql2k job to do the log backup. For some reason, I don't see the
job history.
When it finish running I see the job history "completed sucessfully". Next
morning the history disappeared. I ran the trace over night and search
"%sysjobhistory%", I don't see any transactions that delete the records in
sysjobhistory table.
Don't know why? any ideas?
Thanks,.This is most likely caused by the settings on the "Job System" tab of the SQL
Server Agent Properties dialog box. The default setting is to retain 1000
rows total with 100 per job. If you have many jobs on the server and some of
them running frequently then the records for the job you are describing are
most likely being "pushed" out of the table due to the other volume.
Hope this is helpful.
--
David
"mecn" wrote:
> Hi,
> I have a sql2k job to do the log backup. For some reason, I don't see the
> job history.
> When it finish running I see the job history "completed sucessfully". Next
> morning the history disappeared. I ran the trace over night and search
> "%sysjobhistory%", I don't see any transactions that delete the records in
> sysjobhistory table.
> Don't know why? any ideas?
> Thanks,.
>
>|||David,
Thanks, I think that you are right. I'm going to increase the size to 2000
instead of 1000.
Thanks again,
"mecn" <mecn2002@.yahoo.com> wrote in message
news:%23hmBlapIGHA.3816@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I have a sql2k job to do the log backup. For some reason, I don't see the
> job history.
> When it finish running I see the job history "completed sucessfully". Next
> morning the history disappeared. I ran the trace over night and search
> "%sysjobhistory%", I don't see any transactions that delete the records in
> sysjobhistory table.
> Don't know why? any ideas?
> Thanks,.
>

Missing sysjobhistory in sql job

Hi,
I have a sql2k job to do the log backup. For some reason, I don't see the
job history.
When it finish running I see the job history "completed sucessfully". Next
morning the history disappeared. I ran the trace over night and search
"%sysjobhistory%", I don't see any transactions that delete the records in
sysjobhistory table.
Don't know why? any ideas?
Thanks,.
This is most likely caused by the settings on the "Job System" tab of the SQL
Server Agent Properties dialog box. The default setting is to retain 1000
rows total with 100 per job. If you have many jobs on the server and some of
them running frequently then the records for the job you are describing are
most likely being "pushed" out of the table due to the other volume.
Hope this is helpful.
David
"mecn" wrote:

> Hi,
> I have a sql2k job to do the log backup. For some reason, I don't see the
> job history.
> When it finish running I see the job history "completed sucessfully". Next
> morning the history disappeared. I ran the trace over night and search
> "%sysjobhistory%", I don't see any transactions that delete the records in
> sysjobhistory table.
> Don't know why? any ideas?
> Thanks,.
>
>
|||David,
Thanks, I think that you are right. I'm going to increase the size to 2000
instead of 1000.
Thanks again,
"mecn" <mecn2002@.yahoo.com> wrote in message
news:%23hmBlapIGHA.3816@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I have a sql2k job to do the log backup. For some reason, I don't see the
> job history.
> When it finish running I see the job history "completed sucessfully". Next
> morning the history disappeared. I ran the trace over night and search
> "%sysjobhistory%", I don't see any transactions that delete the records in
> sysjobhistory table.
> Don't know why? any ideas?
> Thanks,.
>

Missing sysjobhistory in sql job

Hi,
I have a sql2k job to do the log backup. For some reason, I don't see the
job history.
When it finish running I see the job history "completed sucessfully". Next
morning the history disappeared. I ran the trace over night and search
"%sysjobhistory%", I don't see any transactions that delete the records in
sysjobhistory table.
Don't know why? any ideas?
Thanks,.This is most likely caused by the settings on the "Job System" tab of the SQ
L
Server Agent Properties dialog box. The default setting is to retain 1000
rows total with 100 per job. If you have many jobs on the server and some of
them running frequently then the records for the job you are describing are
most likely being "pushed" out of the table due to the other volume.
Hope this is helpful.
--
David
"mecn" wrote:

> Hi,
> I have a sql2k job to do the log backup. For some reason, I don't see the
> job history.
> When it finish running I see the job history "completed sucessfully". Next
> morning the history disappeared. I ran the trace over night and search
> "%sysjobhistory%", I don't see any transactions that delete the records in
> sysjobhistory table.
> Don't know why? any ideas?
> Thanks,.
>
>|||David,
Thanks, I think that you are right. I'm going to increase the size to 2000
instead of 1000.
Thanks again,
"mecn" <mecn2002@.yahoo.com> wrote in message
news:%23hmBlapIGHA.3816@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I have a sql2k job to do the log backup. For some reason, I don't see the
> job history.
> When it finish running I see the job history "completed sucessfully". Next
> morning the history disappeared. I ran the trace over night and search
> "%sysjobhistory%", I don't see any transactions that delete the records in
> sysjobhistory table.
> Don't know why? any ideas?
> Thanks,.
>

Monday, February 20, 2012

missing hd partition

. but on the prod i could only view C: even though there is a D:
partition. previously i had scheduled an EM backup to D: partition on
this prod server. last week i noticed that the backup is failing
because D: is not being "seen" by EM. i've read through the BOL but
couldn't find a clue (probably i'm thick) so i'm asking if anyone could
shed a light on how EM "see" the D: partition?maverick wrote:
> hello, we have sqlserver2K on Win2K SP4 on two machines namely prod and
> backup. on backup when i do EM backup and click on the "add" device i
> could view the different hard disk partitions of my server (C:, D:, E:,
> F

. but on the prod i could only view C: even though there is a D:
> partition. previously i had scheduled an EM backup to D: partition on
> this prod server. last week i noticed that the backup is failing
> because D: is not being "seen" by EM. i've read through the BOL but
> couldn't find a clue (probably i'm thick) so i'm asking if anyone could
> shed a light on how EM "see" the D: partition?
>
Verify that the SQL Server service account (check the service
properties) has permissions to read/write on the "missing" partition.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Tracy McKibben wrote:
> Verify that the SQL Server service account (check the service
> properties) has permissions to read/write on the "missing" partition.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
that worked! the account that sqlserver is using doesn't have
permissions on the "missing" partition.
thank you so much Tracy for your help!

missing hd partition

hello, we have sqlserver2K on Win2K SP4 on two machines namely prod and
backup. on backup when i do EM backup and click on the "add" device i
could view the different hard disk partitions of my server (C:, D:, E:,
F:). but on the prod i could only view C: even though there is a D:
partition. previously i had scheduled an EM backup to D: partition on
this prod server. last week i noticed that the backup is failing
because D: is not being "seen" by EM. i've read through the BOL but
couldn't find a clue (probably i'm thick) so i'm asking if anyone could
shed a light on how EM "see" the D: partition?maverick wrote:
> hello, we have sqlserver2K on Win2K SP4 on two machines namely prod and
> backup. on backup when i do EM backup and click on the "add" device i
> could view the different hard disk partitions of my server (C:, D:, E:,
> F:). but on the prod i could only view C: even though there is a D:
> partition. previously i had scheduled an EM backup to D: partition on
> this prod server. last week i noticed that the backup is failing
> because D: is not being "seen" by EM. i've read through the BOL but
> couldn't find a clue (probably i'm thick) so i'm asking if anyone could
> shed a light on how EM "see" the D: partition?
>
Verify that the SQL Server service account (check the service
properties) has permissions to read/write on the "missing" partition.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Tracy McKibben wrote:
> Verify that the SQL Server service account (check the service
> properties) has permissions to read/write on the "missing" partition.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
that worked! the account that sqlserver is using doesn't have
permissions on the "missing" partition.
thank you so much Tracy for your help!

Missing entry in sysfulltextcatalogs

Hi
I've just restored a database from a backup, usually I have to correct the
path of the fulltext index in master.sysfulltextcatalogs after doing this,
but now sysfulltextcatalogs is empty and has no entries. When I right click
the table with the fulltext index I can see that it has a fulltext index
defined.
Has anyone got an idea of what's going on, why is sysfulltextcatalogs
showing up as empty?
Kind Regards,
Allan Ebdrup
I am confused, you restored a database from a backup and you expect the
sysfulltextcatalog table to contain an entry for this catalog?
I take it that the original backup was done on this machine and is not from
a remote server, and that the database have tables which were full text
indexed before you restored the backup.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Allan Ebdrup" <comaeb@.ofir.com> wrote in message
news:ehtEprejFHA.3164@.TK2MSFTNGP15.phx.gbl...
> Hi
> I've just restored a database from a backup, usually I have to correct the
> path of the fulltext index in master.sysfulltextcatalogs after doing this,
> but now sysfulltextcatalogs is empty and has no entries. When I right
click
> the table with the fulltext index I can see that it has a fulltext index
> defined.
> Has anyone got an idea of what's going on, why is sysfulltextcatalogs
> showing up as empty?
> Kind Regards,
> Allan Ebdrup
>
|||BTW - don't you mean you have to correct the path in the database's
sysfulltextcatalogs as opposed to master's?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Allan Ebdrup" <comaeb@.ofir.com> wrote in message
news:ehtEprejFHA.3164@.TK2MSFTNGP15.phx.gbl...
> Hi
> I've just restored a database from a backup, usually I have to correct the
> path of the fulltext index in master.sysfulltextcatalogs after doing this,
> but now sysfulltextcatalogs is empty and has no entries. When I right
click
> the table with the fulltext index I can see that it has a fulltext index
> defined.
> Has anyone got an idea of what's going on, why is sysfulltextcatalogs
> showing up as empty?
> Kind Regards,
> Allan Ebdrup
>

Monday, March 26, 2012

Model backup failed

Model backup failed

Monday, March 19, 2012

Misunderstanding of backup

Mistakenly dropped database in SQL Server! Data recovery?

Mistakenly dropped database in SQL Server! Data recovery?

Monday, March 12, 2012

missing tables and stored procedures after restoring database

missing tables and stored procedures after restoring database

missing tables and stored procedures after restoring database

Missing sysjobhistory in sql job

Missing sysjobhistory in sql job

Missing sysjobhistory in sql job

Monday, February 20, 2012

missing hd partition

missing hd partition

Missing entry in sysfulltextcatalogs

Missing dll file

Blog Archive

About Me