Viewing 15 posts - 46 through 60 (of 1,179 total)
Refer following MS article and configure pass-through authentication so that replication can be set up between domain and workgroup
http://support.microsoft.com/en-us/kb/321822
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 9, 2015 at 4:51 am
Usually you will find it at the same place where copy of .trn files have been kept on secondary server.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 9, 2015 at 4:45 am
There are many factors affecting the database maintenance plan based on the application and type of database and environment. However primarily you can focus on backup strategy, High availability, Database...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 9, 2015 at 4:42 am
Just curious: Are you able to take the backup from Query Analyzer executing command like:
BACKUP DATABASE <dbname> TO DISK = <specify_path>
If getting any error please post it here.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 9, 2015 at 4:14 am
I guess firwall/port might be the issue. Can you try to telnet the port you are using for sql server which is accessible after VPN?
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 9, 2015 at 3:54 am
You can also check the I/O performance of storage before you hand it over for production. Also try all the possibilities of fail over to check the cluster e.g. reboot...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 9, 2015 at 1:33 am
I guess there is no SQL Server issue. Are you able to run SQL SERVER in the physical network which are you connecting through VPN? Connecting/disconnecting the VPN might have...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 9, 2015 at 1:23 am
While executing your transaction you can use hint "TABLOCKX" refer following MS link for further details.
https://technet.microsoft.com/en-us/library/aa213026(v=sql.80).aspx
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 8, 2015 at 4:15 am
check if you can use Try...Catch in your SP for error handling.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 8, 2015 at 1:25 am
http://www.microsoft.com/en-in/download/details.aspx?id=29066
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 8, 2015 at 1:20 am
Carlo Romagnano (4/8/2015)
MyDoggieJessie (4/7/2015)
This assumes that you have a schema in the database named "tmp" otherwise it fails because the schema does not exist.+1
Ahi, ahi, ahi, ahi, ahi, ahi!!!!!!!!!!
:w00t:
+1
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 8, 2015 at 1:00 am
If possible, plan distributor on the separate machine to reduce load on production box.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 7, 2015 at 4:30 am
Are you missing any settings/fine tuning on .net?
.Net application connects remotely? or from the same server?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 6, 2015 at 8:36 am
check your error log are you getting error 3409? If so visit following MS link:
https://msdn.microsoft.com/en-us/library/ms187743.aspx
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 6, 2015 at 7:52 am
To gauge memory and CPU create a dummy load expected on the application database and stimulate the environment as production. However calculate the expected future growth and keep the buffer....
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 6, 2015 at 7:25 am
Viewing 15 posts - 46 through 60 (of 1,179 total)