Re: Backup SQL Server on local PC

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Please provide more info. Are you doing this so you have a version of the
source db to make changes to or is this where you want to store your back
ups?

You could make the back up on the host pc and copy the file over. You
could also use replication to replicate the host [c db onto your pc and then
back it up

--
Sincerely,
John K
Knowledgy Consulting
http://knowledgy.org/

Atlanta's Business Intelligence and Data Warehouse Experts


"WonderMan" <none@xxxxxxxx> wrote in message
news:mn.93ac7d83b541bc3b.88081@xxxxxxxxxxx
Hello,

I am working with SQL Server 2005 and connecting to a databse which is
hosted on a SQL Server 2005 server in another PC.

I tried to make a backup of the database I work with, but the only
possibility I found was to create the backup on the PC which hosts the
database.

I would like to create a local backup, i.e a backup of the database on my
own PC, and not the PC hosting the database.

Is this possible ?

Thank you for your help.




.

Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... with volume Shadow Copy error 800423f4. ... You back up data from a volume that contains a Microsoft SQL Server ... The recovery model of the SQL Server database is configured to use an ... It just ensures backup will continue without reporting the error. ...
    (microsoft.public.windows.server.sbs)
  • Re: Im using sys.master_files.
    ... This I carried out within the Microsoft SQL Server Management Studio when creating or editing a Maintenance Plan. ... Previously I received the error when trying to undertake a differentail backup without a full backup existing. ... However with the differential backup having a changed extension it happily takes the backup! ... current database backup does not exist. ...
    (microsoft.public.sqlserver.server)
  • Re: Start SQLServerAgent job Synchronously
    ... Wayne Snyder, MCDBA, SQL Server MVP ... > call and the caller resumes processing as soon as the call is made. ... > I have a set of SQLServerAgent jobs, each of which runs a BACKUP DATABASE ...
    (microsoft.public.sqlserver.server)
  • Re: Start SQLServerAgent job Synchronously
    ... Wayne Snyder, MCDBA, SQL Server MVP ... > call and the caller resumes processing as soon as the call is made. ... > I have a set of SQLServerAgent jobs, each of which runs a BACKUP DATABASE ...
    (microsoft.public.sqlserver.programming)
  • Re: "Best Practices" way to distribute MSDE
    ... > Restore a users's selected backup. ... for dayly house-keeping I do usually provide scripted job for database ... that file copy operation (not SQL Server backup!) can be performed.. ... my personala advice is to perform dayly house-keeping actions ...
    (microsoft.public.sqlserver.msde)