Viewing 15 posts - 1 through 15 (of 45 total)
I also found the same article googling, but it seems that
'No, Free IBProvider can't work with linked server in MSSQL'
and IBProvider Pro is not free.
Thanks anyway for support.
July 31, 2012 at 6:31 am
It's not a problem to have 2 or more datafiles.
In a case opposite than yours I have problems, since the first datafile mdf contains both system and non system...
June 23, 2011 at 5:04 am
Dipending on their design, some databases have only system objects on file mdf, and other objects data on further file ndf.
That could be the reason for little dimension.
For my experience,...
June 23, 2011 at 2:55 am
I forgot to say that in previous days we installed, for a trial period, FogLight monitor. The Sql Server cluster's nodes were the hosts monitored.
Has anyone experienced similar problems with...
June 23, 2011 at 1:12 am
Remote server has only the 'si' login for our use, I have to it for all local logins, also for 'sa', which, it's true, exists on remote server, but with...
March 31, 2011 at 8:38 am
I map 'sa' and 'pinco', which are both sql server logins, with the same remote login 'si'.
If instead of Sql Native Client I use Ole Db Provider for Sql Server,...
March 29, 2011 at 12:47 am
If you have a test server, with the db, try to run
DBCC DROPCLEANBUFFERS
DBCC FREESESSIONCACHE
to empty the cache and rerun the query. You should have the same resource usage as...
January 14, 2011 at 5:35 am
Try to look in activity monitor, start_time, last_batch, wait_time of your process.
January 14, 2011 at 5:19 am
Hello,
maybe you mean that you prefer not to have big datafiles. You can set a max file size, and create a new one when you need (when the first is...
January 14, 2011 at 4:36 am
Many thank for the scripts and replies.
Steve you're perfectly right, saying 'Schedule log backups based on your needs for data loss and recovery.'
I was considering only space aspects while writing,...
January 14, 2011 at 3:09 am
Thanks for replies,
as Adam says, the only thing I was 'worried' about is the possibility to fill the transaction log during night, and cause disases to users (Hospital databases).
The test...
January 13, 2011 at 5:48 am
You should verify the retention for job history, it could be that you cannot dispose of one month of history, sending the notification solves this problem.
May 13, 2010 at 6:51 am
Hello,
the quickest and simpliest way I'm thinking is to configure a notification in the job properties, to your e-mail adress, selecting the option 'when the job completes'.
May 13, 2010 at 6:48 am
After the first backup script, you can define a cursor on msdb.dbo.backupset
and rerun your script for dbs having last backup date
older than you need.
If you see that at...
May 13, 2010 at 1:44 am
Viewing 15 posts - 1 through 15 (of 45 total)