Viewing 15 posts - 8,071 through 8,085 (of 9,241 total)
chanti2985 (4/12/2010)
backup and restore is always best approach.
that's jumping in both feet first 😉
all this is dependant on the network performance and server performance. Remember with backup\restore you have to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 17, 2010 at 3:35 am
also make sure the workload you pass in is a comprehensive representation of the normal database activity and not just a 2 minute profile session!
you also have the ability to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 17, 2010 at 3:12 am
when referring to key constraints
Primary key does not allow NULLs
Unique key allows a single NULL value
so the 2 are different in that respect
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 17, 2010 at 2:55 am
thank you alen
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 16, 2010 at 3:04 pm
PlaysWithHisFood (4/16/2010)
using the maintenance plan clean up task will also work.
ensure you upgrade to at least SP2 first though
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 16, 2010 at 3:03 pm
no it wont work its looking for files older than 3 days. To delete files for a backup you just created change the day to minutes or seconds like so
set...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 16, 2010 at 4:15 am
which mode are you trying to implement?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2010 at 2:48 pm
copy the file locally and restore from there!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2010 at 2:44 pm
if your issue is around sql server 2005 it would be best to post in the appropriate forum 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2010 at 2:41 pm
babolnart (4/14/2010)
wow that explains it... thanks.. i have the same issue by the way
😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2010 at 10:33 am
is it a cd or dvd based image?
what version of sql server do you have installed and what version is the cd\dvd?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2010 at 10:27 am
i'll check what i have on my server at the weekend and let you know back
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2010 at 8:46 am
it sounds like they may have been separated for adminstrative reasons. That's perfectly valid if that is what you want to do. As the server is licensed from the install...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2010 at 8:44 am
Shabba (4/14/2010)
A quick search within SSC will produce numerous topics on the subject of...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2010 at 8:31 am
THE-FHA (4/14/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2010 at 8:30 am
Viewing 15 posts - 8,071 through 8,085 (of 9,241 total)