Viewing 15 posts - 241 through 255 (of 712 total)
subahan.munthamadugu (7/21/2013)
Hi all,please give command for "backup with norecovery" option.
Jeff gave a nice option but ill give another thought
right click database, select Backup, select backup type and try...
July 22, 2013 at 3:10 am
Sean Pearce (7/18/2013)
durai nagarajan (7/17/2013)
any other guess before i take it to the vendor.Select growth from SYS.MASTER_FILES where name = 'DBName'
32000
July 19, 2013 at 12:02 am
have you tried using ip and sql authentication from local system whether it is connecting or not.
July 17, 2013 at 3:35 am
There is no large imports and the data from this we are taking it to a tempory table and then we are processing it for our use.
any other guess before...
July 17, 2013 at 1:08 am
As said by above users in 32 bit editions do you have /PAE /3GB in boot.ini file and "Lock pages in memory" should be given access for SQL server service...
July 16, 2013 at 11:59 pm
what do you mean by "cannot connect"?
Is it on different domain or something else?
July 15, 2013 at 7:03 am
Is that 2005 box using an alias user to take backup?
July 12, 2013 at 7:55 am
Other than Kerberos no other way for windows authentication?
July 10, 2013 at 7:07 am
On source it is possible but i fear not possible in target server as it will be restoration mode.
why does he want that?
July 10, 2013 at 7:01 am
if i run a query on SSMS using linked server with my windows login.
i got this error "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'"
July 10, 2013 at 6:59 am
Bobby Glover (7/10/2013)
What about the other acoount used for the APP. I imgine they are both domain accounts.
yes
Do you use Kerberos in your environment.
NO
What happens if you use...
July 10, 2013 at 6:56 am
not working
my id is sysadmin on both servers, i get same error
but the service id which is mapped on sql services is working am i missing something.
July 10, 2013 at 6:39 am
we have two accounts one that is running sql agent and the one i am trying
when i execute it using the first one looks fine
the second one i have updated...
July 10, 2013 at 4:42 am
Try these
1. using the sql server port number
2. using the sql server ip address , if this resolves the issue the server might have improper name change , i...
July 9, 2013 at 11:47 pm
if it is temp db space issues why are you worrying about other stuff.
can you post the complete errror and tempdb size and drive details with free space).
July 2, 2013 at 10:27 pm
Viewing 15 posts - 241 through 255 (of 712 total)