Peter,

Transaction logs have to be applied to a full backup that was done BEFORE the transaction logs are backed up. This is why SQL Server advises that you backup your...

To add to our comments, all SQL languages use the same BASIC commands: SELECT, FROM, WHERE, GROUP BY, ORDER BY, UPDATE, DELETE, INSERT and some others.

But the languages differ in...

Got to ask an obvious question....was the differential you are restoring made AFTER the full backup that you restored?

-SQLBill

To get the most accurate information (IMO), run the stored procedure sp_updateusage then run sp_spaceused.

sp_spaceused will return the amount of space used by data, unallocated, free, etc.

Refer to the BOL...

Howard,

The problem is that NULL plus anything is NULL. You can use ISNULL (refer to the Books OnLine for more information).

select ISNULL((select  sum(Amount)

          from  AR_Transactions

         where  Customer_Number = @c),0)...

Run your query through the Estimated Execution Plan checker in Query Analyzer and then run this:

update q12004

set q12004.batch = adnh.batch

from adnh

join q12004

on adnh.phone = q12004.col035

See if there is any difference in...

You could create a role....SPUser for example, grant it execute privilege for every stored procedure and then assign users to that role. It would be a lot of work to...

PL/SQL and SQLPlus are Oracle database languages.

-SQLBill

Peter,

To restore the logs, you have to have a full backup to apply them to. Sahana doesn't have any backup at all.

If a full backup were to be done...

If you aren't sure about deleting it, move it to another location and delete it from the original location. If something stops working, move it back. If everything keeps working...

This is a duplicate post.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=116217

-SQLBill

This is a duplicate post.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=116423

-SQLBill

Unfortunately, you don't have a backup. This type of oops is why the transaction log should be backed up regularly.

I don't think you'll be able to get the data back....

One problem I have found with Active Directory is date/time. Check the system date/time on 1)the SQL Server machine, 2) the end server, 3)the Primary Domain Controller/Backup Domain Controller. Make...

Disclaimer: I have never used SQL Server 7. I use SQL Server 2000.

I believe that in version 7 backup files are stored as filename.dmp. So what you are looking at...