Ninja's_RGR'us (11/21/2011)

---

Yuri55 (11/21/2011)

---

DBCC CHECKDB failed again with error: "Msg 8967, Level 16, State 216, Line 1

An internal error occurred in DBCC that prevented further processing. Contact Customer Support Services."

Need to...

DBCC CHECKDB failed again with error: "Msg 8967, Level 16, State 216, Line 1

An internal error occurred in DBCC that prevented further processing. Contact Customer Support Services."

Need to investigate- Google...

"What's the status of your backups? When was the last clean backup? What recovery model? How often are the log backups run?"

It seems to me that status is bad :angry:-...

Gail,

Thanks for your response- I run DBCC CHECKDB with no_infomsgs 2 times but both times failed after 8 min execution time ("Internal error- contact sys admin"- something like this)- I...

ravisamigo (11/1/2011)

---

Hi,

Now my question is..

Can't we bring secondary back as read-ony by using Tlog backup?

or

can we only bring secondary as read-only with latest full backup of primary ?

Please advice.

Thanks and...

BOL "Moving database files" states that full-text catalog can be moved using Alter Database statement

Sometimes same story happens with sql server linked server (not DB2 only).

I would try: 1) kill process from both sides (Src/Dest) and 2) disable/delete linked server

It seems it happened already as on StandBy server Log Shipping jobs are running successfully 🙂

Just couple more questions: 1) StandBy Server DB is in Loading state- is this OK...

Just to share my experience (make simple test):

1) originally- tempdb has 4 data files. One data file was removed

-sys.sysfiles and sys.database_files return 4 files (old...

Sorry for delay:

1) output from sys.master_files:

tempdevROWSF:\MSSQL\DATA\tempdb.MDF3717120-1128000

templogLOGF:\MSSQL\DATA\templog.LDF262175-1128000

tempdev1ROWSF:\MSSQL\DATA\tempdev1.ndf3717120-1128000

tempdev2ROWSF:\MSSQL\DATA\tempdev2.ndf3717048-1128000

2)output from sys.sysfiles:

tempdevF:\MSSQL\DATA\tempdb.MDF3717120-112800

templogF:\MSSQL\DATA\templog.LDF262175-112800

tempdev1F:\MSSQL\DATA\tempdev1.ndf3717120-112800

tempdev2F:\MSSQL\DATA\tempdev2.ndf3717048-112800

tempdev3F:\MSSQL\DATA\tempdev3.ndf3717120-112800

Thanks

Perry, sorry (early morning in Canada :-))- just to clarify-

sys.sysfiles returns 4 data files fo tempdb,

sys.master_files returns 3 files (same as from Property)

Adi- I certainly tryed Refresh- same 3 files (mdf + 2 ndf)

Perry- I run your query- same result as from sys.sysfiles I mentioned before-

same 3 files and nothing unusual

(sorry,...

Sorry for the response delay (was extremely busy during office hours)-

just to clarify what I actually meant asking my question-

when clustered index was just created or rebuit- physical and...

Here:

http://beyondrelational.com/blogs/brumedishetty/archive/2010/04/29/downgrading-sql-server-enterprise-edition-to-standard-edition.aspx

you can find details about "Downgrading SQL Server Enterprise Edition to Standard Edition"

Good luck 🙂

Gail,

Just to clarify- is this "The index defined the logical order " always true?

I mean cases when you create or rebuild clustered index (still no physical order?)

Thanks,