Viewing 15 posts - 1,831 through 1,845 (of 2,007 total)
Just curious to know more:
•Is it a periodic / recurring activity?
•Do the configured jobs change quite often?
October 18, 2011 at 9:28 am
What do you commonly setup and used Policy in your company as DBA or Database developer ?
Recommeded Reading
Download SQL Server 2008 Policy-Based Management white paper from Microsoft Download...
October 18, 2011 at 9:25 am
Cannot open backup device \\server1\d$\backup\TLshipping\testdb.bak.Operating system Error 5(access denied).
Please verify SQL Server Service Account & its privileges.
October 18, 2011 at 9:14 am
I guess I'm a bit confused as to why you would want an instance root to be on local storage instead of the shared storage. If you have it...
October 18, 2011 at 9:03 am
Just a thought!
Will it not be good to create a new thread?
October 18, 2011 at 8:25 am
I want to automatically generate scripts for SQL Agent jobs
SSMS allows you to generate scripts for jobs (step-by-step) on one click.
October 18, 2011 at 8:21 am
The failure may or may not happen. If it does happen, I will use scripts and re-initialise the data.
Will you not require having a FULL database backup or Snapshot...
October 18, 2011 at 8:17 am
I have researched a bit and have come to the conclusion that the easiest way to do this would be to install another named instance on local storage. Detach...
October 18, 2011 at 8:04 am
I believe few guys here worked on Red Gate software but it’s not the right place to post this issue.
Keep bugging Red Gate support until they help.
October 18, 2011 at 7:59 am
Dev @ +91 973 913 6683 (10/18/2011)
It's too much for log files.
Not necessarily. A log file needs to be as big as it needs to be. If...
October 18, 2011 at 7:33 am
I did not require execute permissions. However the problem resolved after granting VIE DEFINITION permission to the users.
I assumed you already granted that. The same is mentioned in your previous...
October 18, 2011 at 1:48 am
with a 27GB log file
It's too much for log files. Are you not taking log backups frequently ? What's the database recovery model?
short term solution has been to shrink...
October 18, 2011 at 1:40 am
Here my search which should give you some ideas: http://tinyurl.com/6db3qkx
Caution: The link is suspicious.
October 18, 2011 at 1:30 am
Aspet Golestanian Namagerdi (10/18/2011)
October 18, 2011 at 1:13 am
Viewing 15 posts - 1,831 through 1,845 (of 2,007 total)