Hi Gila/Perry,

Thanks for your response even i observed required less down time for this...

Thanks & Regards

Satish

Hi Gail,

Thanks, yes its working fine after move the database files but could you tell me what is the difference on Detach/attach process and above...

Hi Gail,

I observed the files are not moved particular path, currently Data & log files are in 'C' drive itself.....

When i executed below query get successful...

Hi Gila,

I gave correct name of database and now file has moved but after restart the database getting error

Database not accessible....

Thanks & Regards

Satish Saidapur

Hi Peery & Gila,

I test it in my local server getting error while executing below query

Query :-

ALTER DATABASE Test MODIFY...

Thanks Arto,

I change it into NVARCHAR(1000), then its working..

Thanks

Satish

Hi Friends,

I am getting output of above query when i change the path like

DECLARE @MyFileName varchar(50), @COMMAND VARCHAR(100)

SELECT @MyFileName = (SELECT 'C:\DBBACKUP\Full\Store\' +...

Hi Howard,

S3 is the tool of Amazon and it is use for move the data from local desktop to S3 bucket.

PUT is...

Hi,

Before you install please add the Storage, Msdtc and Quorum drive.

Satish

Hi Anand,

Robert is right, change it into run time and one more plus point is incase your Principal server will crash or else updated data...

Hi Lowall,

I am worried about file name. Yes your script is working fine, let me know how do i change it.

Thanks

Satish

Hi Lowell,

Thanks a lot, my issue has been resolve and i have small doubt i am not able to same name on zip file.

...

Hi Poste & Lowell,

Thanks for responding, i will test your script and revert back

Thanks

Satish

Hi John,

I need to fix it as a SP, can any one share me exact script please.

Thanks

Satish

Hi Jonh,

Below script i was used but i am sure this is wrong script.

DECLARE @pathName NVARCHAR(512)

SET @pathName = 'C:\Backup'...