Hi John,

Best option is what Gail has suggested.

Mike Levan (4/4/2009)

---

Actually here is what i am trying to acheive..

I have PRoduction and Stage Server.

1. Restore production database "Employees" backup onto stage

2. Update stage with latest data

3. Backup stage...

Basically do you want to...

shahajic (4/3/2009)

---

Would like to know what will be the state of the database on secondary server is that is in standby mode or no recovery mode upon restoration of transaction...

shahajic (4/2/2009)

---

Hi All,

We have some huge jobs running on sql server db 2005, which create transaction log and this log is backedup up every 15 min and copied over...

Try executing this command dbcc shrinkfile(fileid,target_size)

Target file size value should be greater than the used file size value

For example if used file size is say 90000 MB against total...

What kind of authentication is being used (Nt or SQL) if NT authentication used then you don't have to worry.

Both are from same tables.

Also today I refreshed the database and started compressing table at page level it has thrown same error.

Server: Msg 824, Level 24, State...

Gail,

Initially I got an error when compressing table on one of the file at page. I have posted that error.

Then I have run dbcc page on the page that...

GilaMonster (3/14/2009)

---

Please run a full checkDB and post the results here

DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS

Do you have a clean backup?

The 'invalid encryption key' confuses me....

I have gone through this article but the issue that I...

Krishna (3/11/2009)

---

Which SQL server edition are you using? Right click on SSMS on the database and you can see the "size" and "spaceavailable". If you still have disk space available...

Do you have these commands? xp_restore_database ,xp_restore_log and xp_sqllitespeed_version?

If you have these stored procs, xp_backup_database might have got deleted , to get in that extended proc

use this command

use master

go

exec...

Gail I agree 100 % with you. No need to truncate log, just backup the log.

In case if by mistake it is truncated, take a differential...

Exeucte the following command sp_repltrans this gives you information about transactions that are marked for replication but are not transmitted to distrbution.

If it shows zero rows then physicall verify the...