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 ««12

BACKUP WITH NORECOVERY Expand / Collapse
Author
Message
Posted Monday, July 22, 2013 6:38 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 13, 2014 10:06 PM
Points: 16, Visits: 73
Thanks for your reply
Post #1476320
Posted Tuesday, July 23, 2013 8:09 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 13, 2014 10:06 PM
Points: 16, Visits: 73
Hi all,

backup with .... norecovery option

backup log TEST2LOCATION to disk ='F:\backup\log.trn' with norecovery but it is not possible to take full backup with norecovery option


Thanks,
subahan.M
Post #1476597
Posted Tuesday, July 23, 2013 8:10 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 13, 2014 10:06 PM
Points: 16, Visits: 73
backup log TEST2LOCATION to disk ='F:\backup\log.trn' with norecovery
Post #1476600
Posted Tuesday, July 23, 2013 8:19 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 @ 4:16 AM
Points: 40,194, Visits: 36,599
Please note: 3 year old thread. New questions in a new thread please.


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 #1476604
Posted Tuesday, July 23, 2013 8:27 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:48 AM
Points: 5,878, Visits: 13,007
ooooh, you edited it

---------------------------------------------------------------------

Post #1476609
Posted Thursday, July 25, 2013 8:33 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 13, 2014 10:06 PM
Points: 16, Visits: 73
Hi All,

How to move perticuler table from mdf to ndf ..

Thanks,
subahan munthamadugu.
Post #1477529
Posted Thursday, July 25, 2013 8:37 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:48 AM
Points: 5,878, Visits: 13,007
subahan.munthamadugu (7/25/2013)
Hi All,

How to move perticuler table from mdf to ndf ..

Thanks,
subahan munthamadugu.


Hi, please post new questions in a new thread, you'll get a better response


---------------------------------------------------------------------

Post #1477530
Posted Thursday, July 25, 2013 8:50 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 13, 2014 10:06 PM
Points: 16, Visits: 73
Hi george sibbald ,

thanks for ur reply and i am new for sql server and i want know abt what i asked .
please give me ur sugestions.

Thanks,
Nani.
Post #1477546
Posted Thursday, July 25, 2013 8:54 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:48 AM
Points: 5,878, Visits: 13,007
please start a new thread

---------------------------------------------------------------------

Post #1477552
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse