Hi Craig,

the sp_repldone should be done inside the problem database. [distribution] is the database used by the replication process.

Seems to me you should drop that replication.

If trying to do that leads to errors, you might do the sp_repldone as a quick fix.

Be advised that you will...

Hello,

you could use "DBCC OPENTRAN" to see if there are transactions in the log file, that were not replicated.

If yes, as long as they are not replicated, you will not...

Hello,

to circumvent the text-, ntext-, image- and timestamp-problem i converted this into a template, so with ctrl-shift-m i can insert the proper table name:

-- CREATE A MEMORY TABLE CONTAINING THE...

Hi mgalawin,

try

SELECT cn, employeeID, samAccountName, mail, givenName, sn

FROM OPENROWSET('ADSDSOObject', 'adsdatasource;',

'SELECT sn, givenName, mail, samAccountName, employeeID, cn

FROM ''LDAP://source''

where objectCategory = ''Person'' and objectClass = ''User''

and employeeID = ''*'' and...

If your Backupfile contains more then 1 backups (perhaps you did back up all Databases in one go) you need to add the filenumber to the command line for the...

Hi Charles,

the log file growth in that scenario will happen if the dba thinks that a full backup will cut of the transaction log.

There seem to be quit a lot...

Hi,

log backups are independent from database backups.

If you are using full and differential database backups, you usually store them in a certain place, where you will allways find any differential...

Hi

you can create a linked server to your domain controller.

then

declare @groups table ( grp sysname )

declare @usrs table ( usr sysname, grp sysname )

declare @actgrp sysname

declare @actntgrp sysname

declare

INSERT Personal (Name, ID) SELECT Name, ID

FROM OPENROWSET('MSDASQL',

'Driver={Microsoft Excel-Treiber (*.xls)};

DBQ=<filename>;HDR=NO',

...

Hi,

did you set "Quoted Identifiers on" for the Export? If not, you need to export again with that setting...

regards

karl

Hi,

if they were backing up the file system with any kind of an open file agent

AND

if there were no (or nearly none) transactions written during the backup

you might get back...

Hi,

just so i know - do you guys think it possible that an open transaction getting rolled back on the table might be a reason for this kind of delete...

Hi,

let's say you

rename the old log file,

then restore the db, diff and log backups

stop sql server

rename the new log file

rename the old log file to its original name

start...

oops - forgot to mention that...

- even bulk logged mode should be ok i think.

using a log reader should work even if the db was not empty but created from...