Viewing 15 posts - 8,071 through 8,085 (of 9,244 total)
Jeffrey Williams-493691 (4/17/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 17, 2010 at 2:05 pm
ananda.murugesan
but all existing users appered in new sql 2008 db.
these are the database users, they require linking to a server level login to allow server\database access
ananda.murugesan (4/16/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 17, 2010 at 3:59 am
i host my own its a lot easier. Most ISPs charge to host SQL server databases. Its almost definitely the fact the database connection is not correct.
you may want to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 17, 2010 at 3:50 am
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
Viewing 15 posts - 8,071 through 8,085 (of 9,244 total)