Viewing 15 posts - 8,026 through 8,040 (of 9,244 total)
Bhuvnesh (4/24/2010)
ORShrink the transaction log file
to effectively shrink the log file you will need to back it up first
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2010 at 10:55 am
halifaxdal (4/23/2010)
It seems the bracket is causing the problem, I took away the [], now this issue went away.Thanks for replying.
then the error wasnt network related or instance specific was...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2010 at 9:46 am
varshachyk (4/24/2010)
on one of our server Re-build index job is failing with the below error. Please suggest.
Failed: (-1073548784) Executing the query "ALTER INDEX [PPS_USER_SESSION_COOKIE] ON [dbo].[abc] REBUILD WITH (...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2010 at 9:29 am
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
Viewing 15 posts - 8,026 through 8,040 (of 9,244 total)