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

backup Expand / Collapse
Author
Message
Posted Wednesday, May 21, 2008 5:54 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, October 22, 2008 7:02 AM
Points: 12, Visits: 54
Hello,
can any tell how to take backup in the file/filegroups
please write code for database or table backup
Post #504382
Posted Wednesday, May 21, 2008 7:42 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, March 13, 2014 5:38 PM
Points: 318, Visits: 345
This is easy enough to look up in bol so try to do a little reading next time.

Here's what I got out of bol...

BACKUP DATABASE Sales
FILEGROUP = 'SalesGroup1',
FILEGROUP = 'SalesGroup2'
TO DISK = 'Z:\SQLServerBackups\SalesFiles.bck'
GO


Watch my free SQL Server Tutorials at:
http://MidnightDBA.ITBookworm.com

Read my book reviews at:
www.ITBookworm.com

Blog Author of:
Database Underground -- http://www.infoworld.com/blogs/sean-mccown
DBA Rant – http://dbarant.blogspot.com
Post #504464
Posted Thursday, May 22, 2008 6:34 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 4:45 AM
Points: 2,385, Visits: 1,843
Visit following link for detail:

ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_4deptrbl/html/da0532bd-1d3d-4483-b2ba-944b164a95be.htm



---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #505123
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse