Hi,

actually, if the new production server database was empty at startup and you built the schema from zero, you should be able to recover - if no log backups with...

Hi,

according to Ken Simmons from mssqltips.com you might do something like the following:

SELECT * FROM OPENROWSET('SQLNCLI', 'server=(local);trusted_connection=yes',

'set fmtonly off exec [dbo].[im_get_fn_contact_types]')

http://www.mssqltips.com/tip.asp?tip=1551

regards

karl

hmm...

this is vb-script - don't know if it works for you...

dim fso, file

Set fso = Server.CreateObject("Scripting.FileSystemObject")

Set file = fso.CreateTextFile("c:\test.txt", True)

file.WriteLine("Hallo Welt")

file.Close

set file = nothing

set fso = nothing

karl

Hi,

do you close the file after reading from it?

You can try to wait for 5 seconds before moving the file, in case the file system needs more time to really...

Hi,

the compression rate for the first db is 1:3, for the second db it's 1:2.

Perhaps the problem lies in the data - and litespeed needs a lot of time for...

Usually backup software that compresses the backups on the fly not only needs al lot less space for the backups, it does the backup in less time than native sql...

Hi,

if you map users to logins, which is a writing operation, the lsn-chain for the next log shipment will be broken and you have to initiate logshipping again.

If you...

Hi Chris,

you need to stop the agent to be able to change the log settings...

regards

karl

Hi Jason,

alternatively you might use scptxfr.exe in the following procedure:

----------------------- snip ---------------------------------------

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_ScriptDatabase]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)

drop procedure [dbo].[sp_ScriptDatabase]

GO

SET QUOTED_IDENTIFIER ON...

Hi,

Navision in versions below at least 4.0 is hard on the sql server... it is not optimized for sql server.

We are using Navision 3.7 - and blocking is quite usual....

Hi,

are you talking about windows email profiles? Then no, each profile is associated with exactly 1 exchange mailbox. That mailbox may belong to a distribution group - what ever good...

Yes. Doing the maintenance before the full backup has the additional benefit that if you have to restore, you restore an optimised database...

On the other hand you might try to...

Hi,

did you activate a maintenance plan for index optimation recently? That might explain big diff backup files...

regards

karl

If we are talking about a dedicated SQL Server, why should the dba not have admin permissions? 

If i am responsible for an SQL Server and its performance i do want to have...

Hi dzigrino,

two points:

first, did you have a look at the transaction log and at tempdb while the procedure ran? if sql server treats this insert as one big transaction that...