I don't know why you are getting difference but I tried it in AdventureWorks database on SalesOrderdetail table, the way you mentioned

(Like creating temp table, dumping data from original...

When you do your restore....do you first have to restore the FULL BAK then the LOG TRN after this.

I.e lets say you have FULL BACK Midnight and then 5 TRN...

ALZDBA,

Thanks a bunch for the reply with the script.

Actually I made mistake. I again ran RESTORE and it worked out.

When I dropped table time was 10:53:34 AM and I...

Thanks ALZDBA.

I got it almost work. I opened all the trace files and checked in it and I found when I dropped table and took all the backups. But still...

Thanks Manu & Jeffrey Williams.

I don't see the trace file for the day I created and dropped, so looks like I am out of luck.

looks like you have SQL Server Express Edition, which doesn't support Database Mail. Check this link it might help.

http://weblogs.sqlteam.com/mladenp/archive/2007/07/01/60245.aspx

I think you have to apply service pack to database only.

Yes it works under 2k as well.

Thank you very much nary. It just worked out fine.

I thought by changing compatibility level you can but i might be wrong. So is it possible to do logshipping between 2 different editions of the SQL Server?

Ok then I have another question. I created a table

create table employee

(id INT,

Name VARCHAR(50))

Then Created a Unique Clustered index on that table.

CREATE UNIQUE CLUSTERED INDEX CIX ON EMPLOYEE(ID)

Then...

hello Gurus,

My Question: for example: if you have a database which is static like northwind which is never going to change a lot. So when you run DBCC CHECKDB on...

I disagree with the answers, .ldf is for logfile not for datafile. the question specifically asks for the database files.

SQL Server 2005 does not enforce database filename extensions, but which...

Jeff,

Here comes another question. I just did what you have mentioned in the Script for storing file. It worked fine. I inserted a doc file in database. Now, how do...

todd,

i have been configuring my home machine with free Gmail account and it's been working fine. I have never used gmail business account so frankly speaking i don't know how...