Viewing 15 posts - 9,226 through 9,240 (of 9,241 total)
exactly, BTW also forgot to mention that sa login is also disabled on our sql servers.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 18, 2008 at 3:48 pm
even under virtualisation 64bit isnt necessarily the defacto platform
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 18, 2008 at 3:39 pm
if you plan on using perfom there are a set of key counters to look at, what do you plan to use?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 18, 2008 at 3:38 pm
assuming you have the arrays available 😀
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 18, 2008 at 8:15 am
humbleDBA (6/18/2008)
I don't wholy disagree with you on the 64-bit vs 32-bit. In fact in most cases, and for DB servers that have large DBs and require performance then 64-bit...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 18, 2008 at 8:13 am
just for reference and to help others with similar problems what was it you did? 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 18, 2008 at 8:05 am
what monitoring tool(s) are you using?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 18, 2008 at 7:56 am
our databases all get set to SA ownership and SA has a secure password.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 12, 2008 at 11:36 am
done this already, use xp_regread to read the values from the registry and output
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 12, 2008 at 11:32 am
depending what you are auditing, there would be more options of tracing but you need advanced auditing enabled
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 12, 2008 at 11:17 am
the IP address of the machine would also be recorded with the SQL login, depends what you are auditing
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 12, 2008 at 11:17 am
detach and re attach, also dont forget to script off your logins and take those across too
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 11, 2008 at 8:43 am
ok what logical drives does windows have available on your laptop?
(i.e. do you have a drive E on the laptop?)
How are you attaching the database via SSMS gui or T-SQL...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 11, 2008 at 8:22 am
nagnrik (6/10/2008)
------------------------------
Attach database failed for Server 'Nagraj-PC\SQL2005'. (Microsoft.SqlServer.Express.Smo)
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
Unable to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 11, 2008 at 8:16 am
i figure the restore should be complete at that point though. When creating the job i had the plan backup and restore the target db to the secondary server and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 30, 2007 at 6:41 am
Viewing 15 posts - 9,226 through 9,240 (of 9,241 total)