Can you please give me some more detail. (Links , write-ups ).

Have you done this in your environment. Can you share some explanatory documents.

Tanx:-D

Hi

I used DBCC CHECKDB WITH ESTIMATEONLY

and found that around 2Gb tempdb space needed to run DBCC CHECKDB.

Then i performed DBCC CHECKDB WITH PHYSICAL_ONLY on that 300GB DB. It...

The server didn't go offline also was not restarted i checked the logs.

When i run DBCC Checkdb manually on the 300Gb database the process stays in executing state without give...

What kind of backup did you perform.

Use the following query to check the list of files in your .bak file.

RESTORE FILELISTONLY FROM DISK = N'D:\DB_name.BAK'

And also verify if the...

Hi,

Backup and copy jobs as well as the restore jobs are working fine.

Only the alert job is failing.

There are no errors recorded.

I tried creating similar job and scheduled it

The job has full db backup and clean up task older than 3 days.

But the newly created job also...

That was the error found in error log.

Im not sure of the security issues but there was around 20 GB of free memory in the server.

The step at which...

Sorry guys.

Jeff Moden (9/6/2009)

---

I guess I don't understand a couple of things... when you say you want to "randomly generate the 3rd and 4th column", do you mean just for...

Thanks guys.

I want my result to randomly generate the third and the fourth column.

This is the table that i have

create table test (Name varchar(10), start_time datetime, end_time datetime)

insert into test...

Im not able to attach the .xls that i made.

its for calculating the duty hours spend by a person.

The 1st two columns contain the start time and end time of...

Did you try this

http://msdn.microsoft.com/en-us/library/ms189663(SQL.90).aspx

GSquared (8/5/2009)

---

How long should the proc take to finish?

I have some that take a few milliseconds, and some that take an hour or more, and none of them are "broken".

You...

I couldn't try that as they wanted me to...

I waited for about 20-30 min , then had to kill it as the...

Good catch Ashwin 😉