Viewing 15 posts - 8,026 through 8,040 (of 9,241 total)
striker-baba (4/23/2010)
I can back up the log. But, it is not necessary.and the database is in full recovery mode.
if the database is in full recovery model then log backups are...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2010 at 9:20 am
Sourav-657741 (4/23/2010)
1. Can you please suggest me a suitable query to find out whether any database is in "offline" status in the SQL Server?
the following will work for sql2005 on
select...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2010 at 7:42 am
Can you supply a little more info on the error. Check the SQL server and Windows event logs
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2010 at 7:26 am
Paul
Good link. As Slava points out though the memory release process can be very slow especially under pressure. For that reason I, like others, err on the side of caution...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2010 at 2:02 am
What does the following query produce on each server? Can you post the results?
select serverproperty('Collation')
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 23, 2010 at 3:13 pm
2 words, Regional Settings!!
The default collation out of the box is dynamic 😉
The collation is defined by the regional settings on the server, you can change but if you accept...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 23, 2010 at 2:51 pm
is there a firewall in between the IIS server and the SQL Server?
Can you ping the SQL Server from the IIS box?
Can you telnet successfully to the SQL Server instance...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 23, 2010 at 2:47 pm
if you're wise you will setup a test system first and test this thoroughly. The jump from SQL7 to 2005 is huge and the database compatability level will possibly not...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 23, 2010 at 2:44 pm
i have experienced backing up SQL Server databases using DPM and i gotta say i'm not a great fan of the product at all. I use Redgate SQLBackup to backup...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 23, 2010 at 2:37 pm
you want to ensure the OS has at least 4GB to manage the process memory efficiently
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 23, 2010 at 2:32 pm
Guys
just checked my SQL Server 2008 Ent x64 instance and guess what?? Yep, you got it, it's the same as yours
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 23, 2010 at 8:40 am
open the database diagram and right click then select copy to clipboard. Once on the clipboard open your favourite image editor Paint.net and paste into a new image
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 22, 2010 at 7:08 am
emily-1119612 (4/21/2010)
I gave up on xp_delete_file.
it does work extremely well if you take the time to get to grips with its parameters
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 22, 2010 at 6:01 am
karthik -450760 (4/21/2010)
I tried to login to the server through Remote desktop connection and I got the error message ,
" The account is configured to prevent you from...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 22, 2010 at 5:58 am
CirquedeSQLeil (4/21/2010)
But can the OP logon to the same server that is having the problems with that user account?
is why I suggested login to server if account or domain is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 21, 2010 at 3:08 pm
Viewing 15 posts - 8,026 through 8,040 (of 9,241 total)