Viewing 15 posts - 31 through 45 (of 45 total)
Just for information, after rebooting the server, I still get the same error if I try to add a new datafile.
It's quite strange.
February 16, 2009 at 6:56 am
Many, many thanks, I will test.
sb
February 16, 2009 at 6:50 am
I will try to know more details about our supplier's request. My difficulty is tha i can't talk with the programmer directly, but with the supplier, who has to contact...
February 16, 2009 at 6:47 am
Guest User account is a dangerous account. I would not grant any permissions to it. Why dont you create a login for this and assign permissions to it individually?
the...
February 16, 2009 at 6:28 am
the drive the transaction logs are on has enough free space.
I actually backup regularly only non system DBs transaction logs, system DBs have simple recovery model (but msdb, I've noticed...
February 16, 2009 at 6:16 am
Question, what drive(s) are your system DBs on?
system DBs are on the same drive of non system DBs, it's a SAN disk.
transaction logs are on a different drive.
Also, does your...
February 16, 2009 at 5:56 am
Thanks, it's the first think I checked. Disk space is not a problem, I have about 100 gb for datafiles and about 11 Gb on Sql Server unit.
The question about...
February 16, 2009 at 3:45 am
yes, I am. I think all of our databases have only one filegroup=primary...
February 13, 2009 at 6:10 am
Thanks for suggestion, I've grown an existing datafile from 4000 to 4500, autogrowth to 5000 mb. this worked. But then, retrying to add a datafile of 500 Mb, I got...
February 13, 2009 at 6:01 am
this is what I was thinking, the message is exactly the reason why I need to add the file!
To be sure, I've tryed again, the message is:
TITLE: Microsoft SQL Server...
February 13, 2009 at 5:39 am
Thanks a lot, the hardest work will be to prepare for each database the scripts to delete unwanted data...
Very useful the COPY_DATA option, many thanks!
sb
February 13, 2009 at 2:19 am
Please, could you tell me how to find the job id and from which tables delete its records? The tables I looked in had details different from the ones I...
January 28, 2009 at 6:19 am
I completely agree, there is the risk of compromise all other databases, which are very critical.
So many thanks for your suggestions, I think we will convince the supplier to make...
January 21, 2009 at 7:27 am
you mean that a user having the role db_datawriter on msdb has by default the same privilege on all databases in that instance?
(I'm not so expert, so sorry if I...
January 21, 2009 at 7:19 am
Viewing 15 posts - 31 through 45 (of 45 total)