Viewing 15 posts - 121 through 135 (of 815 total)
Many Thanks Steve.
So if I have to move the TDE enabled database to other server where TDE is not enabled, is my approach correct;
1) Remove TDE on Source database
2)...
November 8, 2011 at 7:08 am
Stop the Agent Service of sql which will kill all running job. Then restart the service again and disable the job.
November 4, 2011 at 2:56 am
Is the job stopped/disabled? If not stop it and disable it untill further investigation.
November 4, 2011 at 12:56 am
I think the best option is to disable the job which is filling the log untill the job properly investigated.
run the below steps in your database only after the...
November 4, 2011 at 12:47 am
need to investigate what activity this job is doing which is filling log. If you can then stop the job or if the server is not crucial stop the agent...
November 4, 2011 at 12:06 am
check if there is any job running. If required stop it else configure your logfile setting to autogrow to unrestricted growth.
November 3, 2011 at 11:55 pm
I also agree with alter database recommendation and we should be aware that detach/attach is going to be depreciated in future SQL Versions. So be habitual to alter database 😀
Just...
November 3, 2011 at 11:53 pm
when you configuring the backup path, you should be getting two option. One for network location and other for local.
You might be overlooking the local path option where you have...
November 3, 2011 at 4:04 am
from my point of view, it looks like disk issue which is getting network problem.
Is it possible for you to move system database files to some other disk. Also dont...
November 3, 2011 at 3:47 am
if you really getting error then you would be getting "additional information" with your error. Paste it here.
Also the way you connecting. Is it sql authentication or windows authentication?
November 3, 2011 at 3:37 am
can you copy/paste your error by masking whatever specific to your environment.
November 3, 2011 at 3:03 am
what are the best pratices for Moving Database files from one location to another location?
Points to be considered :-
1) Must have enough space at new location for files to grow...
November 3, 2011 at 2:58 am
I think, if your most of the search(where query) is based on the primary key then Clustered index is advisable but if its getting updated very frequently and not being...
November 3, 2011 at 2:39 am
if everything is correct, try instance name with port number.
How many instance of sql server on that server?
November 3, 2011 at 2:17 am
If you decided about log-shipping then you can modify your log restore script with two option :-
1) you can delay the log restore by "n" minutes if users are connected....
November 2, 2011 at 11:52 pm
Viewing 15 posts - 121 through 135 (of 815 total)