Viewing 15 posts - 8,836 through 8,850 (of 9,244 total)
out of the 2 i prefer Redgate SQL Backup!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 11, 2008 at 4:39 am
jjssilva (10/10/2008)
I'm clueless here.
the date and time shown above is 10PM not AM (22:47).
what you are seeing is the installed date and time i believe
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 10, 2008 at 7:25 am
you would have to restore
stuff.mdf
stuff.ldf
then create the extra filegroups\files and move objects from the primary file\group to the new files\groups
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 7, 2008 at 2:07 pm
homebrew01 (10/3/2008)
There are applications that connect using 'sa'.
no application user account should need to connect using 'sa', especially a web user account. Assigning 'sa', this is all too common...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 7, 2008 at 2:02 pm
SBS comes with SQL server built in
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 7, 2008 at 5:55 am
how are you creating\starting the trace?
is it a server side trace?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 7, 2008 at 5:46 am
yulichka (10/6/2008)
can't see the location where we moving
:exclamationmark: :exclamationmark:
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 6, 2008 at 9:59 am
timscronin (10/3/2008)
domain admin
not a good idea, remove that straight away. Create yourself a standard domain user account (no admin) and use sql server config manager to change the user account...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 3, 2008 at 8:30 am
you could still use backup\restore
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 2, 2008 at 5:34 pm
timscronin (10/2/2008)
The sql server is running under the same account for all our sql servers, never changed
user account or local system?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 2, 2008 at 5:31 pm
there is no upgrade path for express. detach the databases and re attach them under sql2005 standard, also script off the logins and apply those too
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 2, 2008 at 5:29 pm
check you have spelt it correctly
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 2, 2008 at 5:42 am
also bear in mind regular autogrowths can leave you with physical file fragmentation 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 1, 2008 at 4:02 pm
what account are the SQL services running under?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 1, 2008 at 3:53 pm
shakti (10/1/2008)
updations
now there's a word for you
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 1, 2008 at 3:46 pm
Viewing 15 posts - 8,836 through 8,850 (of 9,244 total)