In your script, the log is truncated. Is there any way to guarantee shrinking a transaction log file without truncating it? I just backed up the log, but i did...

Thanks for the replies, but I think the insert of triggers may not be easily implemented because, as you said, we need to trace which user has inserted what rows,...

Thanks Sugesh. What you said sounds logical. Do you know if there is any detailed reference of the registry key values used in SQL Server 2005? It may be even...

Thanks much!

Del Piero

Sorry I mean to say, I removed the group and NOT just removed sysadmin role from the group.....

Thanks,

Del Piero

No I still haven't got an answer ...I tried using some methods discussed in other forums/user groups, but it's still failing ........

Del Piero

Hi all,

 I have got another problem in setting up the witness in database mirroring. I am trying to use a SQL Server Express Edition as a witness. The instance name...

Regarding TheSQLGuru's reply, there is also one thing i am worrying about... In SQL Server 2005 Books Online, if you click any topic about Database Mirroring, there is a notice...

Sorry in (2) it should be "clicked "Remove mirroring" for an existing mirroring pair" instead of existing log shipping pair. Everything I asked is about mirroring and nothing about log...

Thanks all!

Thanks all!

Del Piero

Thanks. Just curious, do you know if this is available in SQL Server 2005 then?

SQLBill .. sorry I don't know why I sent an empty message ... So, the tape drive is external, they installed it after MSSQL was installed, and they did do...

SQLBill,

BTW, is there any restriction that SP4 must be applied on top of SP3a? Or it is OK to apply SP4 on top of SP3 as well? I guess both...