You do realize that you don't need the data in these tables to restore a database, right?

krypto69 (6/11/2013)

---

declare @dbname sysname

set @dbname = db_name()

print @dbname

select backup_start_date,backup_finish_date, -- << look here, you have a comma when you shouldn't

from msdb..backupset

where database_name = @dbname and type = 'D'

Msg...

Looks like the backup jobs are running on the wrong server or your principal and mirror databses are active on the wrong servers (meaning what should be your principal database...

Tell us more about the backup process. Are you using a third party backup solution or native backups. Are you backing up locally or directly to a network...

krypto69 (6/11/2013)

---

Lynn,

results:

LOG_BACKUP

Pretty sure it's because the Unitrends software is not working as it should. But I'm stuck with the UNitrends device to backup out servers.

So my thought was that I...

Have you tried using the file to restore the database to test or development server to verify that the backup file is good?

That is the real test.

NO. First step is figure out why...

You need to figure out why the t-log is growing. Shrinking it will not solve the problem, it would only be a band aid.

First step, run the following and...

Krishna1 (6/11/2013)

---

create table remarks ( remark varchar(1000)

create procedure P1 as

begin

while loop

begin

.....

insert into remarks ()

...

Instead of posting pictures of the execution plans, how about attaching the actual execution plans (as .sqlplan files) instead. The pictures don't tell as much as the execution plans...

This:

SELECT

distinct @@SERVERNAME AS ServerName,

CASE

WHEN J.Name IS NOT NULL THEN cast(1 as varchar) -- job exists

ELSE 'does not exist' -- 0 Job does not exist

END AS IsExisting,

CASE J.enabled

WHEN...

Looking at this:

text 16 0 0

text 16 0 0

text 16 0 0

You do realize that the 16 bytes is simply the pointer to the data. What about the data...

You also need to remember that these employers are getting hundreds, if not more, resumes for the positions they post. Just because you feel you are a close match...

These are the improvements that have been added to SQL Server over the last few releases. IIRC, this was not the behavior in SQL Server versions from 2000 and...

Sean Lange (6/10/2013)

---

Krishna1 (6/4/2013)

---

Thanks it worked for the missing tables.

But when i ran it showed me the procedures which are depedent of other procedures. First shot i thought the "called"...