i have n number of databses in my server . I want to remove all the databses which are not in use for the past 6 months . Is there any way , i...
I have my ms sql 2000 server and it is linked to ms access database in another server .
The linked server some times fails to fetch any result for...
I have a production server and test server.Both have different users.I need to refresh the test server with the data from the production server and...
my client want to setup logshipping say between servers at austraila and newzeland.
He wants the transfer of information over network in...
Can u please share ur experience like the dos and donts in your experience.
quote:Originally posted by Reddy
I have done logshipping.Then tried role change,it sucessfully changed the role.After role change the two jobs responsible for logshipping namely...
I built logshipping,then i have done role change ie i made my
secondary server as production server .I have done some server updation
you are absoultely correct satya,i cam to know about this while performing role change.
now my error is
i created the package
i am in the process of testing rolechage.
i am using windows2003 and sql2000 sp3
my questions is
will i have to follow create dts package,transfer...
yes it is posible with two developer edition,i referred,but is there any constraint with respect to service pack,because when i run select @@version...
can i try logshipping testing on 2 sql 2000 developer editions machine.
one is the primary and another one as standby and monitor.If i try this...
My domain controller is windows2000 and i want to install one of the server with windows2003 and sql2000 and want to make windows2003 and...
Great,you have done it.But my position is,i want to cluster sql2000 in windows2003,can you please tell me from were i can get information...
can you please suggest some resourcess to refer before i am going for windows2003 and sql2000 clustering.
Thanks and regards
Can i make use of logshipping in sql2000 enterprise edition to logship in to a sql2000 server with standard edition.
i am using windows2003 and sql 2000 standard edition.
The maximum capacity of sql engine in this situation is 2gb of ram.
If i have say 4 gb of...
I have a crazy requirement ie can we convert database in sql2000 to sql7
MY CASE HERE IS.HOW TO MAKE SQL MAIL WORKS.
THE SCENARIO IS
1 I HAVE SQL 2000 INSTALLED IN A PROXY SERVER CONNECTED TO MY WEB SERVER THROUGH...
Separate names with a comma.