Viewing 15 posts - 31 through 45 (of 131 total)
Hi Gila/Perry,
Thanks for your response even i observed required less down time for this...
Thanks & Regards
Satish
September 24, 2012 at 6:53 am
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...
September 24, 2012 at 6:15 am
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...
September 24, 2012 at 5:12 am
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
September 24, 2012 at 4:28 am
Hi Peery & Gila,
I test it in my local server getting error while executing below query
Query :-
ALTER DATABASE Test MODIFY...
September 24, 2012 at 4:05 am
Thanks Arto,
I change it into NVARCHAR(1000), then its working..
Thanks
Satish
September 11, 2012 at 6:24 am
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\' +...
September 11, 2012 at 12:19 am
Hi Howard,
S3 is the tool of Amazon and it is use for move the data from local desktop to S3 bucket.
PUT is...
September 10, 2012 at 11:55 pm
Hi,
Before you install please add the Storage, Msdtc and Quorum drive.
Satish
September 6, 2012 at 12:23 am
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...
September 6, 2012 at 12:19 am
Hi Lowall,
I am worried about file name. Yes your script is working fine, let me know how do i change it.
Thanks
Satish
September 3, 2012 at 10:35 pm
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.
...
September 3, 2012 at 12:07 am
Hi Poste & Lowell,
Thanks for responding, i will test your script and revert back
Thanks
Satish
September 1, 2012 at 10:58 am
Hi John,
I need to fix it as a SP, can any one share me exact script please.
Thanks
Satish
August 31, 2012 at 4:48 am
Hi Jonh,
Below script i was used but i am sure this is wrong script.
DECLARE @pathName NVARCHAR(512)
SET @pathName = 'C:\Backup'...
August 31, 2012 at 4:27 am
Viewing 15 posts - 31 through 45 (of 131 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy