<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Duncan Pryde
»
Default Backup Directory
35 posts, Page 2 of 4
««
1
2
3
4
»
»»
Default Backup Directory
Rate Topic
Display Mode
Topic Options
Author
Message
Sree Divya
Sree Divya
Posted Wednesday, February 23, 2011 2:26 AM
SSCrazy
Group: General Forum Members
Last Login: Tuesday, April 23, 2013 10:52 PM
Points: 2,118,
Visits: 343
Good qUESTIONS..
I SAW THIS TYPE QUESTIONS VERY RARE
Post #1068108
Duncan Pryde
Duncan Pryde
Posted Wednesday, February 23, 2011 2:39 AM
Hall of Fame
Group: General Forum Members
Last Login: Today @ 2:03 AM
Points: 3,046,
Visits: 1,307
Following James' observations, I've requested that the question be changed to apply only to SQL Server 2005, and the explanation reworded to add that you can in fact use SSMS 2008 to change the default backup directory.
Again, apologies to anyone that knew about the Facets method and got the question wrong because of that.
(No apologies however to anyone that didn't know about that way of doing it and thought you could set it in the same place as the default locations for data and log files
)
Duncan
Post #1068109
paul.knibbs
paul.knibbs
Posted Wednesday, February 23, 2011 3:12 AM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 6:28 AM
Points: 1,258,
Visits: 4,259
I picked a random answer because I was interested to see what the actual answer was...interesting to know!
Post #1068118
michael.kaufmann
michael.kaufmann
Posted Wednesday, February 23, 2011 5:51 AM
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, February 06, 2013 11:51 PM
Points: 1,263,
Visits: 1,079
SUPER SQL STAR (2/22/2011)
GOOD MORNING ..MORNING I LEARNED NEW TOPIC THANKS..
The directories for the default data files, log files and backups are stored in the system registry. As mentioned already you have the ability to change the default data and log directories using SQL Server Management Studio, by right clicking on the server name and selecting properties and navigating to the Database Settings page as shown below.
...
Super SQL Star,
are you Greg Robidoux and is this your pseudonym here on SSC?
If you aren't, please give credit to Greg and quote that you copied from his excellent post (
http://www.mssqltips.com/tip.asp?tip=1583
), as Tejaswili Patil already pointed out.
Regards,
Michael
Post #1068168
SKYBVI
SKYBVI
Posted Wednesday, February 23, 2011 6:22 AM
Ten Centuries
Group: General Forum Members
Last Login: Monday, May 20, 2013 12:10 AM
Points: 1,197,
Visits: 3,226
The question is wrong.
We can change from SSMS too...
Why did i got wrong answer???
Regards,
Sushant
Post #1068188
tejaswini.patil
tejaswini.patil
Posted Wednesday, February 23, 2011 6:29 AM
Ten Centuries
Group: General Forum Members
Last Login: Tuesday, April 19, 2011 1:59 AM
Points: 1,042,
Visits: 234
Hi,
In SQL Server 2008, we can change it from SSMS by right clicking Instance name.
But in SQL Server 2005, it was possible by modifying registery.
The question is not wrong but it is applicable to 2005 and not to 2008.
Duncan has already said this in earlier posts. Kindly read earlier posts.
Regards,
Tejaswini
Post #1068199
Koen Verbeeck
Koen Verbeeck
Posted Wednesday, February 23, 2011 6:40 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Today @ 6:39 AM
Points: 9,376,
Visits: 6,472
michael.kaufmann (2/23/2011)
SUPER SQL STAR (2/22/2011)
GOOD MORNING ..MORNING I LEARNED NEW TOPIC THANKS..
The directories for the default data files, log files and backups are stored in the system registry. As mentioned already you have the ability to change the default data and log directories using SQL Server Management Studio, by right clicking on the server name and selecting properties and navigating to the Database Settings page as shown below.
...
Super SQL Star,
are you Greg Robidoux and is this your pseudonym here on SSC?
If you aren't, please give credit to Greg and quote that you copied from his excellent post (
http://www.mssqltips.com/tip.asp?tip=1583
), as Tejaswili Patil already pointed out.
Regards,
Michael
Busted!
(unless he really is Greg Robidoux
)
How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
Member of
LinkedIn
. My blog at
LessThanDot
.
MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1068203
Lady Di
Lady Di
Posted Wednesday, February 23, 2011 6:48 AM
SSCrazy
Group: General Forum Members
Last Login: Wednesday, March 27, 2013 12:06 PM
Points: 2,706,
Visits: 133
I answered SQL Server Management Studiop because in SQL Server 2008, we can change the default backup directory in it.
Select facets on the instance of SQL Server and change the value of Backup Directory.
In the question, it was not specified if it was SQL Serv 2005 or 2008.
Post #1068212
SKYBVI
SKYBVI
Posted Wednesday, February 23, 2011 6:55 AM
Ten Centuries
Group: General Forum Members
Last Login: Monday, May 20, 2013 12:10 AM
Points: 1,197,
Visits: 3,226
@ lady di....
Same with me...
I got wrong answer
Regards,
Sushant
Post #1068221
MG-148046
MG-148046
Posted Wednesday, February 23, 2011 7:07 AM
SSCommitted
Group: General Forum Members
Last Login: Today @ 6:08 AM
Points: 1,624,
Visits: 1,925
I answered based on SSMS 2008. I haven't used the 2005 client tools in quite some time and the question did not specify which version of SQL tools was being used
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
Post #1068235
« Prev Topic
|
Next Topic »
35 posts, Page 2 of 4
««
1
2
3
4
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
