Hi all, I know you all gonna direct me to to memory issue, with below error. But would like to know if there is any time beeing, fix for this issue,...
Can someone eloborate this? i am getting little confused.. :(
http://www.mssqltips.com/tip.asp?tip=1823
Schema in SQL Server is an object that conceptually holds definitions for other database objects such as tables,views,stored procedures etc. The main...
To my knowledge you can simply backup and do th erestore to get the database back on DEV, but if you need to re impliment replication on the same...
Nope they wont get deleted but, they will not be able to access the database to which they have permissions to.
Deepak, If its active-active cluster, you need to install hotfix on both the clustered instances, and if its active-passive lone you should go for...
Thanks for the reply........ I cant use SCM and the article stuff is too heavy.... is there a simple way to check if one of the windows service is...
HI Friends, As you all know we SQL DBAs get bugged up when a windows patching is scheduled as if its production servers we would be intimated by...
HI thanks again,Ok, here’s the issue. My app team asked me to get the hosts names which have been connecting to SQL server databases from past 1...
Ok, thanks......what if i need to continously monitor or log that activity?
HI All, I have peculiar request from my client and that is he needs the host names from where the processes are being connected in the seence he...
Thanks for the link satya....no i cant do that as this india box is production one.... well, as told in the link given by you when i configure a...
Sure, will try that option....but i am curious to know is there any method to split the full-backup in sql server 2005?...which upon restoring must...
Rohit and Satya thanks for the reply Well we are moving this backup to trouble shoot an issue, its only one time move not a scheduled one…actually...
Hi Guys,May be my subject looks absurd,but that's the problem i am supposed to copy a backup file from a server which is located in India to USA and...
i guess there are no special steps to be fallowed....i would go with stopping replication when i do a manual failover next time. [:)]
yes it would be best to stop replication, but how ever practically in an active passive cluster replication should be working fine if it failovers...
no subscriber is not on cluster, its some where in other box.... so are there any prerequisites to be taken or any specific steps to be followed?
can anyone help me please
Separate names with a comma.
