Viewing 15 posts - 6,481 through 6,495 (of 7,467 total)
try
DBCC rebuild_log ('Dorian Event Archiver', 'yourdrivepath\Dorian Event Archiver_Log.ldf')
?
September 21, 2005 at 8:04 am
I also found this in my archive :
-- DBCC rebuild_log (dbname [, filename])
-- -- -- -- Create new database with same name, stop SQL Server, replace the MDF file from...
September 21, 2005 at 3:04 am
did you check usp_AttachDBWithMissingLogFile ?
http://www.sqlservercentral.com/columnists/awarren/attachanddetachagain.asp
September 21, 2005 at 3:01 am
What if you use EM to attach the db and you fill out the logfiles ?
September 21, 2005 at 2:47 am
from BOL :
The DIFFERENCE function compares the SOUNDEX values of two strings and evaluates the similarity between them, returning a value from 0 through 4, where 4 is the best...
September 21, 2005 at 2:43 am
did you try sp_attach_single_file_db ?
September 21, 2005 at 2:25 am
from BOL :
Before enabling AWE, consider the following:
September 21, 2005 at 2:20 am
September 20, 2005 at 2:08 am
here's the test result :
Msg 8618, Level 16, State 2, Line 1
The query processor could not produce a query plan because a worktable is required, and its minimum row...
September 20, 2005 at 12:50 am
there ara SAN systems that have an archiving option, meaning datafiles not used for x time migrate to tape until called for.
I've only seen the concept-picture, but have never seen...
September 14, 2005 at 1:29 pm
- what kind of transaction are you using ?
- what kind of connection isolation level are you using ?
- what kind of lock-mechanism is active when the sp is being...
September 14, 2005 at 1:22 pm
just a sidenote :
keep in mind ssc is running out of memory because we are !
September 14, 2005 at 1:42 am
Viewing 15 posts - 6,481 through 6,495 (of 7,467 total)