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

MSDTC

Hi,

I am running SQl 7.0 (SP4) on Windows XP Professional (SP2). Whenever I try an insert/update type of activity, the System returns the following message :

Server: Msg 8501, Level 16, State 3, Line 2
MSDTC on server 'SERVER' is unavailable.

However, all the required services including MSDTC are running on the System.

Please help ASAP.

Thanks & Regards - Rajesh Pathak

It sounds like DTC is turned off on the other machine. Can you confirm that it is on and try again?

Thanks,
Sam Lester (MSFT)

|||Hello Sam,

Thanks for the prompt reply. As a matter of fact, trying any operation on the Server System which itself runs SQL 7.0 returns the MSDTC not running message. If it works on the Server System then I can try debugging problems on other Client Systems.

Kindly let me have probable resolution to this.

Thanks & Regards - Rajesh Pathak