If i write this code

backup database to disk='Path'

Now what should i use to include date in backup name likewise

testbackup01-01-2009.bck

Now access is denied but when i try with command prompt allows me to copy

declare @logid as int

declare @backup_file as varchar(200)

declare @neerav as varchar(200)

--Select media_set_id of last backup

set @logid=(select max(media_set_id) from

msdb..backupmediafamily

where physical_device_name like

'D:\Testdatabase%')

--Select exact backup device name if you create backup...

Yes folder is opening as expected

hi all,

It is giving me invalid drive specification in 'other location'

set @komanda = 'copy'+' '+@backup_file+' Other location'

exec xp_cmdshell @komanda

when i run this in cmd prompt it gets copied

What might...

sorry for providing incomplete information.My another system is in differenent geograhical location

Dear Gilamonster,

Another CPU means another system.

We are preparing one system to hold all sql server backup

but it will be done automated,as when i use xcopy to destination from source it...

hi ps,

Explain?

could you please elaborate??

hi,

I did using SSEM..

HOW THIS GOING TO AFFECT MY DB PERFORMANCE?

We have OLTP system our db slows after certain point.To rectify this we have to delete log.But this is temporary.

Any...

SCTIPUSERS

0SCTIPUSERSPRIMARYSCTIPUSERS

255tSCTIPUSERSPRIMARYINCORPORATIONTYPES

0INCORPORATIONTYPESPRIMARYPERFSTAT_B1_EXT

0PERFSTAT_B1_EXTPRIMARYPERFSTAT_B1_EXT

2_WA_Sys_SUPP_CODE_05EEBAAEPRIMARYPERFSTAT_B1_EXT

3_WA_Sys_FILENO_05EEBAAEPRIMARYPERFSTAT_B1_EXT

4_WA_Sys_BidNo_05EEBAAEPRIMARYPERFSTAT_B1_EXT

5_WA_Sys_SO_SRNO_05EEBAAEPRIMARYITEMCHARACTERISTICS

0ITEMCHARACTERISTICSPRIMARYtblBidFormsFlow

0tblBidFormsFlowPRIMARYtblBidFormsFlow

2_WA_Sys_FormName_0618D7E0PRIMARYtblBidFormsFlow

3_WA_Sys_FormID_0618D7E0PRIMARYtblBidFormsFlow

4_WA_Sys_URL_0618D7E0PRIMARYtblBidFormsFlow

5_WA_Sys_PreFormID_0618D7E0PRIMARYtblBidFormsFlow

6_WA_Sys_PostFormID_0618D7E0PRIMARYtblBidFormsFlow

7_WA_Sys_Active_0618D7E0PRIMARYtblBidFormsFlow

8_WA_Sys_AddedOn_0618D7E0PRIMARYAUTONOMOUSFORMMASTER

0AUTONOMOUSFORMMASTERPRIMARYTenderAwards

0TenderAwardsPRIMARYITEMPARAMETER_NDP

1PK_ITEMPARAMETER_NDPPRIMARYSMS_DETAILS

0SMS_DETAILSPRIMARYtblSupplierLogold

0tblSupplierLogoldPRIMARYITEMCONFIG

0ITEMCONFIGPRIMARYtblEQC

1PK_tblEQCPRIMARYtblEQC

2_WA_Sys_Supp_Code_070CFC19PRIMARYtblEQC

3_WA_Sys_BidNo_070CFC19PRIMARYtblEQC

4_WA_Sys_PRCMANU_070CFC19PRIMARYtblEQC

5_WA_Sys_STOLST_ATTCH_070CFC19PRIMARYtblEQC

6_WA_Sys_MAX_STAFF_070CFC19PRIMARYtblEQC

7_WA_Sys_CERT_TEST_070CFC19PRIMARYtblEQC

8_WA_Sys_PostDate_070CFC19PRIMARYAUTONOMOUSFORMSECTIONS

0AUTONOMOUSFORMSECTIONSPRIMARYTipActions

0TipActionsPRIMARYSTOREDIR_MINOR_NDP

1PK_STOREDIR_MINOR_NDPPRIMARYSMS_MASTER

0SMS_MASTERPRIMARYITEMCONFIGCHARACTERISTICS

0ITEMCONFIGCHARACTERISTICSPRIMARYAUTONOMOUSFORMSECTIONSANDHEADERS

0AUTONOMOUSFORMSECTIONSANDHEADERSPRIMARYTipTriggers

0TipTriggersPRIMARYCITY

1PK_CITYPRIMARYTE_NDP

1PK_TE_NDPPRIMARYSMS_PLACEHOLDER

0SMS_PLACEHOLDERPRIMARYITEMFORMULADESCRIPTION

0ITEMFORMULADESCRIPTIONPRIMARYtblFormSign

0tblFormSignPRIMARYStateWiseTax

0StateWiseTaxPRIMARYStateWiseTax

2_WA_Sys_FileNo_09003183PRIMARYStateWiseTax

3_WA_Sys_Supp_Code_09003183PRIMARYStateWiseTax

4_WA_Sys_BidNo_09003183PRIMARYStateWiseTax

5_WA_Sys_Schedule_09003183PRIMARYStateWiseTax

255tStateWiseTaxPRIMARYAUTONOMOUSFORMULADESCRIPTION

0AUTONOMOUSFORMULADESCRIPTIONPRIMARYranjantest

0ranjantestPRIMARYranjantest

2_WA_Sys_MajorStore_09353BADPRIMARYranjantest

3_WA_Sys_LabelName_09353BADPRIMARYranjantest

4_WA_Sys_OrderBy_09353BADPRIMARYranjantest

5_WA_Sys_Pkey_09353BADPRIMARYranjantest

6_WA_Sys_DirCode_09353BADPRIMARYranjantest

7_WA_Sys_FormName_09353BADPRIMARYranjantest

8_WA_Sys_Section_09353BADPRIMARYranjantest

9_WA_Sys_Mandatory_09353BADPRIMARYranjantest

10_WA_Sys_ContentType_09353BADPRIMARYranjantest

11_WA_Sys_Javascript_09353BADPRIMARYranjantest

12_WA_Sys_width_09353BADPRIMARYranjantest

13_WA_Sys_height_09353BADPRIMARYranjantest

14_WA_Sys_StyleOfContent_09353BADPRIMARYranjantest

15_WA_Sys_multiselect_09353BADPRIMARYranjantest

16_WA_Sys_DataSource_09353BADPRIMARYranjantest

17_WA_Sys_ID_09353BADPRIMARYranjantest

18_WA_Sys_TableName_09353BADPRIMARYranjantest

19_WA_Sys_FieldName_09353BADPRIMARYranjantest

20_WA_Sys_SourceTable_09353BADPRIMARYranjantest

21_WA_Sys_SourceField_09353BADPRIMARYranjantest

22_WA_Sys_DestinationTable_09353BADPRIMARYranjantest

23_WA_Sys_DestinationField_09353BADPRIMARYranjantest

24_WA_Sys_Locked_09353BADPRIMARYranjantest

25_WA_Sys_ColWidth_09353BADPRIMARYranjantest

26_WA_Sys_visible_09353BADPRIMARYTmp_RTemp

0Tmp_RTempPRIMARYTEDATA_NDP

1PK_TEDATA_NDPPRIMARYSOHEADER

0SOHEADERPRIMARYSOHEADER

255tSOHEADERPRIMARYITEMFORMULAVALIDATION

0ITEMFORMULAVALIDATIONPRIMARYAUTONOMOUSVALUETYPES

0AUTONOMOUSVALUETYPESPRIMARYTmp_RTemp1

0Tmp_RTemp1PRIMARYTNDATA_NDP

1PK_TNDATA_NDPPRIMARYPERFSTAT_B3

0PERFSTAT_B3PRIMARYPERFSTAT_B3

2_WA_Sys_SUPP_CODE_0AFD888EPRIMARYPERFSTAT_B3

3_WA_Sys_FILENO_0AFD888EPRIMARYPERFSTAT_B3

4_WA_Sys_BidNo_0AFD888EPRIMARYPERFSTAT_B3

5_WA_Sys_RCNo_0AFD888EPRIMARYBANK_MASTER

0BANK_MASTERPRIMARYTmp_RTemp2

0Tmp_RTemp2PRIMARYtblBannerAds

0tblBannerAdsPRIMARYtblBannerAds

2_WA_Sys_Banner_Display_0B528E49PRIMARYtblBannerAds

255ttblBannerAdsPRIMARYcomgtc1

0comgtc1PRIMARYSTATEMASTER

0STATEMASTERPRIMARYtblUserLog

0tblUserLogFILEGROUP2

Query output was likea bove

hi ,

It is giving invalid object name for above query.

We have sql server 2000...

One question apart from above

If i add one more log file to my database.how this will help...

hi all,

Result is same as posted above and i am not using non cluster index

where i am going wrong?

Thanks,

Nero

THANKS TO ALL FOR HELP

hi all,

Thanks for your support

i have successfully created cluster index on target filegroup.

I have one mdf,one ndf and one ldf.i also deleted cluster index as said by you.

How i am...