Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Server Database Backup Expand / Collapse
Author
Message
Posted Monday, July 20, 2009 1:24 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 27, 2010 1:12 AM
Points: 133, Visits: 48
I want to take backup of my server database at my local machine........ how can i do this......

Thanks in advance
Post #755556
Posted Monday, July 20, 2009 3:02 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, November 10, 2014 2:21 AM
Points: 2,223, Visits: 3,652
EDIT - Double Post.




Pradeep Singh
Post #755607
Posted Monday, July 20, 2009 3:05 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, November 10, 2014 2:21 AM
Points: 2,223, Visits: 3,652
vaibhav.a (7/20/2009)
I want to take backup of my server database at my local machine........ how can i do this......

Thanks in advance


By running BACKUP DATABASE
i'd suggest you read BOL on how to backup a database.

see here





Pradeep Singh
Post #755608
Posted Monday, July 20, 2009 3:20 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 27, 2010 1:12 AM
Points: 133, Visits: 48
No, actually i want to take it from my local machine only........we are connected to server.........without altering any settings at the server side......
Post #755615
Posted Monday, July 20, 2009 3:25 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, November 10, 2014 2:21 AM
Points: 2,223, Visits: 3,652
vaibhav.a (7/20/2009)
No, actually i want to take it from my local machine only........we are connected to server.........without altering any settings at the server side......


You can take database backup from anywhere(client or server). If you provide a local path to backup a database, it's local to the server not the client.(means the backup will be stored on the server itself)
If you want you backup on your local machine. there are two ways.
1. backup database on server. Copy the backup file to your local machine
2. backup database using a shared path pointing to your client(of course, you need a shared folder on client's machine)
backup database mydb to disk='\\myMachine\myBackupFolder\myDB.bak'






Pradeep Singh
Post #755619
Posted Monday, July 20, 2009 4:54 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 1:37 PM
Points: 40,662, Visits: 37,127
ps (7/20/2009)
[quote][b]2. backup database using a shared path pointing to your client(of course, you need a shared folder on client's machine)
backup database mydb to disk='\\myMachine\myBackupFolder\myDB.bak'



That will only work if the service account that SQL is running under has full read and write permissions on that share and folder.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #755652
Posted Monday, July 20, 2009 5:22 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, November 10, 2014 2:21 AM
Points: 2,223, Visits: 3,652
Thanks Gail





Pradeep Singh
Post #755661
Posted Monday, July 20, 2009 6:23 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Monday, December 22, 2014 3:26 AM
Points: 14,205, Visits: 28,536
And, if you're backing up a production system, if that system is using differential backups, you should backup using the COPY ONLY option so that you're not interferring with the chain of backups on the production system.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of:
SQL Server Query Performance Tuning
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #755692
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse