Viewing 8 posts - 1 through 8 (of 8 total)
Jarret, you are right I was quite confused with to much information.
I set the filter for the textdata LIKE:
INSERT%, UPDATE%, DELETE%, %sp_prepexec% and %sp_execute and I got only two lines...
October 28, 2004 at 8:15 am
Yesterday I move master, model and msdb from one directory to another (in a demo database) and it works fine. I used document 224071 from support.microsoft.com to do it.
Two...
June 20, 2003 at 4:07 pm
I mean...if the master,model, and all the other databases where placed in D:\mssql\data in serverA I put them in D:\mssql\data in serverB, and then startup SQL2000 serverB.
June 19, 2003 at 12:50 pm
I don't want to attach the files, just put them in the same driver than the SERVERA.
I'm planning backup and restore the system databases too (master, model and msdb).
Then it...
June 19, 2003 at 11:35 am
Maybe I did not explain my task very clear.
I have to move an SQL2000 from serverA
to serverB with differents IPs.
ServerA will not be a Database server anymore, but it will...
June 19, 2003 at 9:23 am
Neder: The serverB will have a different name and a different IP.
Johnsonj: Unfortunately I can not your method, becouse I will not have both machines at the same time.
For been...
June 19, 2003 at 7:54 am
Also I red that I have to run the commands (in server B):
sp_dropserver 'SERVERA'
and then
sp_addserver 'SERVERB','local'
June 18, 2003 at 5:47 pm
Viewing 8 posts - 1 through 8 (of 8 total)