Viewing 14 posts - 46 through 59 (of 59 total)
SQL Server wont release memory even if it is not using all of it.
you should leave sufficient amount of memory to the OS for its functioning.
By using max memory setting,...
November 9, 2011 at 1:48 am
SKYBVI (11/8/2011)
You can look :-C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\LOG
that's default location of it, if you haven't changed it
This is not where job history are stored. They are in msdb...
November 8, 2011 at 7:15 am
Does the service account have required privileges?
November 5, 2011 at 6:34 pm
Simplest way is to use Import-Export wizard. Right click your database>Tasks>Export data.
follow the instructions by the wizard.
November 5, 2011 at 11:10 am
Option 1 is much better. your lsn chain is not broken. 🙂
November 4, 2011 at 9:47 am
try running the script using sqlcmd. -i parameter allows you to use the script.
November 4, 2011 at 9:42 am
The backup file may contain multiple backups within the file. "With File=n" clause allows you to restore a particular backup from the file.
November 4, 2011 at 9:39 am
In simple recovery mode, log space is marked for reuse after SQL Server issues a checkpoint. In full/bulk logged recovery mode, only backup log marks the used space for reuse...
November 4, 2011 at 9:37 am
you can query sys.dm_db_session_space_usage to see which session utilized tempdb heavily. The session(s) using huge IO will be the one using large amount of memory.
also check for open transactions.
November 3, 2011 at 10:09 am
If there is a job to purge bakup history, the query *might not* give you database names whose log backups have been taken.
November 2, 2011 at 8:35 am
No this is not possible. You can manually update the Ids though (identity_insert=on)
November 1, 2011 at 7:43 am
smallmoney (10/29/2011)
With DB Mirroring, do transactions get applied to the mirror first then the principle? Or is it the other way around?Thanks
If mirroring is in asynchronous mode, transactions are committed...
October 30, 2011 at 4:18 am
Viewing 14 posts - 46 through 59 (of 59 total)