MSSQL 2000- Backup Activity on a Network Machine

Hi,
I am using an Enterprise Manager and i have created a Database Maintainance Plan, can anybody guide me as to how to create backup on a remote machine.

I also mapped that device(say M/c B) onto my server box(M/c A) but i am not able to see that particular location in my backup activity screen.

Can this be done in the first place ?

Regards,
Tahirwe need some clarification.

do you want to backup databases on machine A to machine B or do you want to manage backups of databases that are on machine B from machine A?|||Yes i want to backup databases on machine A to machine B through Enterprize manager.|||While doing the backup on a networked remote machine which has been given full rights the job fails giving this error

BACKUP failed to complete the command BACKUP DATABASE [qa_tm_bdr_fix2] TO DISK = N'\\192.168.156.7\DBBackup\MUMSV075\qa_tm_bdr_fix2 _db_200612262300.BAK' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT|||Is your SQL Instance on A running under the system-account? The system account had no rights on B.

But there should be a more useful messge somewhere about why the job fails. Maybe in the errorlog? Have looked at the details in the jobhistory?|||Lexiflex is right. Make sure that the service account running the SQL server on B has enough permissions on the share (on A) where it should write the backup file. So in your case the account under which SQL Server B is running should have the permissions on the \\192.168.156.7\DBBackup share. I assume you allready shared the folder ... The problem Lexiflex is referring to is that the 'local system account' from machine A is not the same as the 'local system account' on machine B ... although it looks like it's the same one, it's definitely not ! You shouldn't run SQL Server under the local system account ... ever.

Been there, done that, worked fine.

Gr,
Yveau|||I am betting this is the problem as well. You will need to change the sql server and sql agent accounts to run under a domain account that has rights to your backup location.|||Thanks a lot for all ur help......it works......

Regards,
Tahir

MSSQL 2000 Activity Logs

Does the SQL server logs the information on when a database has ben
deleted, attached, deatached, and so on?
This morning I recived a call from remote site that the aplication won't
connect to the server. It turns out that the user database has disapeared
from the server. I can't see it in the EM, nor I can see the .mdf/.ldf files
on the disk. The SQL server logs (from the EM) just show me that the
database was opened (started) at some time this weekend, and that's it.
Are there more detailed logs, wich I was unable to find?
Mario
"I can do it quick. I can do it cheap. I can do it well. Pick any two."
Mario Splivalo
msplival@.jagor.srce.hrHi,
I feel that SQL Server wont store any information of that sort by default.
If you keep enabled the profiler then you can see the command DROP DATABASE
, by using that you can identify the user who has dropped it. But old data
can not be retrived.
Thanks
Hari
MCDBA
"Mario Splivalo" <majk@.fly.srk.fer.hr> wrote in message
news:slrnc5td57.f2.majk@.fly.srk.fer.hr...
> Does the SQL server logs the information on when a database has ben
> deleted, attached, deatached, and so on?
> This morning I recived a call from remote site that the aplication won't
> connect to the server. It turns out that the user database has disapeared
> from the server. I can't see it in the EM, nor I can see the .mdf/.ldf
files
> on the disk. The SQL server logs (from the EM) just show me that the
> database was opened (started) at some time this weekend, and that's it.
> Are there more detailed logs, wich I was unable to find?
> Mario
> --
> "I can do it quick. I can do it cheap. I can do it well. Pick any two."
> Mario Splivalo
> msplival@.jagor.srce.hr|||On 2004-03-22, Hari Prasad <hari_prasad_k@.hotmail.com> wrote:
> Hi,
> I feel that SQL Server wont store any information of that sort by default.
> If you keep enabled the profiler then you can see the command DROP DATABAS
E
> , by using that you can identify the user who has dropped it. But old data
> can not be retrived.
>
Yes, when I have the profiler running, then I can see what's going on. But,
most of the time, I don't keep the profiler up.
Is there a way to tell SQL server 'do, please, keep logs of who and when
created/dropped/attached/deatached databases'?
Mike
--
"I can do it quick. I can do it cheap. I can do it well. Pick any two."
Mario Splivalo
msplival@.jagor.srce.hr|||Mario
You can run SQL Server Profile to capture those commands and save it to the
table.
As far as I know with SQL Server 2005 you will be able to define a trigger
on a table or even on a database ( I am not certain) for drop table events.
"Mario Splivalo" <majk@.fly.srk.fer.hr> wrote in message
news:slrnc5tjfd.p0k.majk@.fly.srk.fer.hr...
> On 2004-03-22, Hari Prasad <hari_prasad_k@.hotmail.com> wrote:
default.
DATABASE
data
> Yes, when I have the profiler running, then I can see what's going on.
But,
> most of the time, I don't keep the profiler up.
> Is there a way to tell SQL server 'do, please, keep logs of who and when
> created/dropped/attached/deatached databases'?
> Mike
> --
> "I can do it quick. I can do it cheap. I can do it well. Pick any two."
> Mario Splivalo
> msplival@.jagor.srce.hr|||On 2004-03-22, Uri Dimant <urid@.iscar.co.il> wrote:
> Mario
> You can run SQL Server Profile to capture those commands and save it to th
e
> table.
So, if I'm not running the profiler at the moment that actuall event of
droping/deleting the database was taking place, I have no way of seeing what
happened.
The funniest thing is that the missing database was published for
replication, so you can't just delete it from the EM. If you try to delete
the file from the disk (using Windows Explorer, for instance), it will tell
you that the file is in use (because SQL server is using it).
But, SQL server was running all the time (uptime is more than 6 mths), and
the database just dissapeared. No .mdf files found on the disk, no errors
(that I can find) on the SQL server. If I run the NTFS-Undelete utility (i
tried several ones) I can find dozens of deleted files (some were deleted
more than 6 months ago!), but none of the files are my database files.
At this point of time I have no way or knowledge to explain what exactley
happened.
Mike
--
"I can do it quick. I can do it cheap. I can do it well. Pick any two."
Mario Splivalo
msplival@.jagor.srce.hr|||On 2004-03-22, Mario Splivalo <majk@.fly.srk.fer.hr> wrote:
> On 2004-03-22, Uri Dimant <urid@.iscar.co.il> wrote:
>
I browsed the transaction log for the master database, and found that
database was deleted
Mike
"I can do it quick. I can do it cheap. I can do it well. Pick any two."
Mario Splivalo
msplival@.jagor.srce.hr

MSSQL 2000 - cant connect to DB from remote computer

Please bare with me as I do not have much knowledge in this area with MSSQL.

I have installed MSSQL 2000 Developer and I have setup a database which I am able to connect to and work fine with from the actual server MSSQL is installed on.

The problem comes in when i try to connect to that same database from a different remote server. It will not connect to the DB from this remote server but I know all the connection information is correct so its something on the MSSQL DB server causing this and not on this remote server.

Someone I know has had this problem and has fixed it but they wont tell me how. All I know is they said something about manually opening the ports on the MSSQL server and he also said when you set it to dynamicly determine the port that MSSQL is listening on it errored out. however if you set it staticly to 1433 it worked fine.

Ive also installed SP4 in attempt to fix this but no luck with that either. And I can also get the same exact remote server to connect to completely different DB server without issues.

If anyone can please help walk me through this I would be greatly appreciate and I am also willing to pay some money if it will make my life easier.Can "Developer Version" be connected from a remote client?|||While these (http://msdn2.microsoft.com/en-us/library/ms175043.aspx) directions are specifically for SQL 2005, I'm pretty sure that they'll work for SQL-2000 too.

-PatP|||Ronin- Yes it can be done.

Pat- The firewall is completely disabled. It says Windows Firewall and ICS(internet connection sharing) is disabled when I try to go to the firewall settings so I dont think thats the problem unless I have to enable it and then do this but that doesnt make much sense.|||can anyone help?|||Which SQL network libraries did you select?

-PatP|||named pipes, tcp/ip, nwlink ipx/spx, VIA giganet

Msmerge_genhistory problems

Hi,
I have 12 merge replications (1 Pub, 2 Subs) with remote distributor.
Recently all replications were failed. The error message is :
Cannot insert duplicate key row in object 'MSmerge_genhistory' with unique
index 'unc1MSmerge_genhistory'.
I investigated and discovered that the procedure sp_MsMakegeneration is
responsable for produce the error on line:
update dbo.MSmerge_genhistory set guidsrc = @.genguid, guidlocal = @.genguid,
coldate = @.dt where generation = @.gen
The problem is intermittent.
Error: 2601, Severity: 14, State: 3
Has anyone saw the same problem ?
Thanks
Rodrigo Varella
is this applicable?
http://support.microsoft.com/kb/276427/en-us
and how about
http://groups.google.com/group/microsoft.public.sqlserver.replication/msg/6f9a6ad3c148beef?dmode=source
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Rodrigo Varella" <RodrigoVarella@.discussions.microsoft.com> wrote in
message news:B45D4DE6-B2F9-4B0E-BD89-9FF6A6B3DEA7@.microsoft.com...
> Hi,
> I have 12 merge replications (1 Pub, 2 Subs) with remote distributor.
> Recently all replications were failed. The error message is :
> Cannot insert duplicate key row in object 'MSmerge_genhistory' with unique
> index 'unc1MSmerge_genhistory'.
> I investigated and discovered that the procedure sp_MsMakegeneration is
> responsable for produce the error on line:
> update dbo.MSmerge_genhistory set guidsrc = @.genguid, guidlocal =
> @.genguid,
> coldate = @.dt where generation = @.gen
> The problem is intermittent.
> Error: 2601, Severity: 14, State: 3
> Has anyone saw the same problem ?
> Thanks
> Rodrigo Varella
>
>
|||Hi Hilary,
Thanks about the articles, but I had seem them before. My environment is
SQL 2000 full patched.
Rodrigo Varella
"Hilary Cotter" wrote:

> is this applicable?
> http://support.microsoft.com/kb/276427/en-us
> and how about
> http://groups.google.com/group/microsoft.public.sqlserver.replication/msg/6f9a6ad3c148beef?dmode=source
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Rodrigo Varella" <RodrigoVarella@.discussions.microsoft.com> wrote in
> message news:B45D4DE6-B2F9-4B0E-BD89-9FF6A6B3DEA7@.microsoft.com...
>
>
|||can you reinitialize and redistribute the snapshot to the subscribers?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Rodrigo Varella" <RodrigoVarella@.discussions.microsoft.com> wrote in
message news:FCB2167B-556B-4642-BE3A-F7513044ACB4@.microsoft.com...[vbcol=seagreen]
> Hi Hilary,
> Thanks about the articles, but I had seem them before. My environment
> is
> SQL 2000 full patched.
> Rodrigo Varella
> "Hilary Cotter" wrote:
|||I also found this - it looks like its from a PSS incident.
http://www.gobrien.net/kb/sox/sox/01/11/28/X700048.txt
It suggests dropping the index.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Rodrigo Varella" <RodrigoVarella@.discussions.microsoft.com> wrote in
message news:FCB2167B-556B-4642-BE3A-F7513044ACB4@.microsoft.com...[vbcol=seagreen]
> Hi Hilary,
> Thanks about the articles, but I had seem them before. My environment
> is
> SQL 2000 full patched.
> Rodrigo Varella
> "Hilary Cotter" wrote:
|||Hilary,
The procedure solves the problem!
Thank you!
Rodrigo Varella
"Hilary Cotter" wrote:

> I also found this - it looks like its from a PSS incident.
> http://www.gobrien.net/kb/sox/sox/01/11/28/X700048.txt
> It suggests dropping the index.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Rodrigo Varella" <RodrigoVarella@.discussions.microsoft.com> wrote in
> message news:FCB2167B-556B-4642-BE3A-F7513044ACB4@.microsoft.com...
>
>
|||I sometimes get this. I think it happens when you have an unreliable
environment - is this true in your case?. The fix is to run DBCC
DBREINDEX on the affected index.
Rodrigo Varella wrote:
> Hi,
> I have 12 merge replications (1 Pub, 2 Subs) with remote distributor.
> Recently all replications were failed. The error message is :
> Cannot insert duplicate key row in object 'MSmerge_genhistory' with unique
> index 'unc1MSmerge_genhistory'.
> I investigated and discovered that the procedure sp_MsMakegeneration is
> responsable for produce the error on line:
> update dbo.MSmerge_genhistory set guidsrc = @.genguid, guidlocal = @.genguid,
> coldate = @.dt where generation = @.gen
> The problem is intermittent.
> Error: 2601, Severity: 14, State: 3
> Has anyone saw the same problem ?
> Thanks
> Rodrigo Varella
>
>
|||I have more than 3.000 subscriptions and more than 100 publications. We have
used replications since 2000. We reindex all tables every day. I have never
seem this problem before. My enviroment is checked constantly. We discovered
the duplicate row in msmerge_genhistory using the snapshot procedure. I have
no idea the origin of the problem. It happened suddenly.
Rodrigo Varella
"JE" wrote:

> I sometimes get this. I think it happens when you have an unreliable
> environment - is this true in your case?. The fix is to run DBCC
> DBREINDEX on the affected index.
> Rodrigo Varella wrote:
>
|||I'm running inot the same problem, what was snapshot procedure you used to
resolve this? The link referenced is no longer viewable.
Thank you,
Pauly C
"Rodrigo Varella" wrote:
[vbcol=seagreen]
> I have more than 3.000 subscriptions and more than 100 publications. We have
> used replications since 2000. We reindex all tables every day. I have never
> seem this problem before. My enviroment is checked constantly. We discovered
> the duplicate row in msmerge_genhistory using the snapshot procedure. I have
> no idea the origin of the problem. It happened suddenly.
> Rodrigo Varella
> "JE" wrote:

MSDTC configuration problem

Hi.
My application needs to do distributed transaction on remote Sql server.My
application can be run from workstations(XP professional) or from SQL server
2000...
Limitations for this application are
Worksations wont be having SQL server installed.
I cannot give administrative rights on the SQL server 2000 system( i can
give administrative rights in the SQL server itself but not for the whole
server system)
I created a sample application which has a class for doing distributed
transactions which is derived from ServicedComponent. This application when
run on SQL server 2000 runs fine.It runs fine when worksation also has SQl
server.
But i tried to run this application from a worksation where SQL server is
not installed it doesnt work.Then i configured workstations MTC to point to
remote server and when i created workstaion's login on the server machine as
administrator then the application works...but if i remove the administrator
rights on the system it doesnt...I read in the article TO CONFIGURE MSDTC
needs administrative rights on the server as well as the client.But after
configuration is over i removed the administrative right and kept it as
Standard user or restricted user it doesnt work.But since Our system cannot
give administrative logins for all the clients this would not work.

> is there any other way to make this work!!
Hello,
Did you give the workstation login the appropriate permisssions in SQL
Server? Did you tried to use SQL account to login?
Thanks,
Mohamed Sharaf
MEA Developer Support Center
ITWorx on behalf Microsoft EMEA GTSC