Viewing 15 posts - 43,726 through 43,740 (of 49,552 total)
williamminor (10/15/2008)
I'm on the correct machine. I change the command prombpt over to d and ran the sqlservr.exe - fand got the same message as the previous one
Are you working...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 16, 2008 at 1:16 am
Just to check, you are running that on the server?
Find where the exec is. I don't know your dir structure. Something like this
C:\Program Files\SQL Server\MSSQL\MSSQL\Binn
Change to that dir and you...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 15, 2008 at 4:19 pm
I'm going to have to leave it here, it's past midnight. I'm sure someone wlse will be able to help.
Once you get SQL running from the the command line,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 15, 2008 at 4:12 pm
What files are there in the E:\Program Files\Microsoft SQL Server\MSSQL\data\ directory?
Open a command prompt. (not the run dialog)
type
sqlservr.exe -f
If it gives an error or anything else strange, post the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 15, 2008 at 3:33 pm
And what are the names of the tempDB data and log files in the E:\Program Files\Microsoft SQL Server\MSSQL\data\ directory?
Can you shut the service down and bring SQL up from...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 15, 2008 at 3:15 pm
Ok, so what does the 2000 equivalent return?
select * from master..sysaltfiles where dbid = 2
Please in future post SQL 2000 questions in the 2000 forums. If they're in the 2005...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 15, 2008 at 3:12 pm
What does the following return?
select * from sys.master_files where database_id = 2
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 15, 2008 at 3:07 pm
Look up the UNPIVOT command in books online. I think it should do exactly what you're after.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 15, 2008 at 2:56 pm
What syntax?
1) Is the server running?
2) Are there any errors in the error log? (if you've not sure, post the entire thing)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 15, 2008 at 2:55 pm
Lynn Pettis (10/15/2008)
Here's an answer you might hear where I work:The SAN will never go down.
Yeah, right. Sure it won't. <sigh>
I actually have seen a SAN go down. Not only...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 15, 2008 at 2:49 pm
You can't update the system tables on 2005, and you shouldn't try anyway. It's the quickest way to really stuff things up.
Can you post any errors from the error log...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 15, 2008 at 2:32 pm
ananda.murugesan (10/15/2008)
Any one give me tips, how to recovery data?
To put it very bluntly, you don't.
Why don't you have backups?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 15, 2008 at 2:29 pm
Leo (10/15/2008)
Hi Gila,Have you got a code for Index Rebuild with full scan? I am using SQL 2000.
Thanks.
No such command. Full scan applies to statistics updates, not index rebuilds.
See DBCC...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 15, 2008 at 2:27 pm
Leo (10/15/2008)
1. Does Simple Recovery Model not backup the log? If do so, I will ignore the shrink.
No. In simple log records are discarded at regular intervals. It's not possible...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 15, 2008 at 2:22 pm
Leo (10/15/2008)
So you mean, Just 'Index Rebuild' then Backup the DB? No Defrag Or Shrink?
Rebuild does everything that defrag does and more.
Shrink, as Lynn and Jack said, is not a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 15, 2008 at 2:18 pm
Viewing 15 posts - 43,726 through 43,740 (of 49,552 total)