Viewing 15 posts - 6,226 through 6,240 (of 9,722 total)
If this is an interview question, I second what Dan said. Read up on replication so you can learn enough to get by.
But if I'd been asked that question...
March 23, 2011 at 10:51 am
The only advice I can give you is to engage PerfMon and either Profiler or a server-side trace to see what (if any) activity is going on.
It may very well...
March 23, 2011 at 8:50 am
HowardW (3/23/2011)
Can you connect to the named instance from Management Studio on a different machine or does it also get a connection error?
This is a stand alone laptop. It's not...
March 23, 2011 at 8:42 am
Do you have lots of large data types or images on this database?
March 23, 2011 at 8:34 am
What version of Litespeed?
How many files are you trying to restore?
Can you post the script?
EDIT: Almost forgot to ask, does the restoring box have Litespeed installed?
March 23, 2011 at 8:30 am
Jack Corbett (3/23/2011)
March 23, 2011 at 8:29 am
You didn't give it a target_size?
Run SP_WHO2 to see if anything is blocking the process. Double-check the hard drive to make sure it isn't full. Double-check the tempdb (and...
March 23, 2011 at 8:24 am
Also, why are they not in synch? Did something break? Was something stopped?
March 23, 2011 at 8:21 am
Are you restoring natively, using the Litespeed console, or using a restore job / script created by Litespeed?
Are you restoring to the same box that the backup was made on...
March 23, 2011 at 8:17 am
It depends.
I know that answer blows, but it really does depend.
1) Database shrinking or File shrinking?
2) Through the GUI or a DBCC command?
3) If you used the DBCC command, please...
March 23, 2011 at 8:16 am
HowardW (3/23/2011)
Is the SQL Server Browser Service Running?
It wasn't. Just started it, retried starting SQL Server Agent Service and got the same error message.
March 23, 2011 at 8:13 am
Again, what Gail said.
But in my original analogy, the parts of the plate covered with cookies were the active VLFs and the empty parts of the plate were the inactive...
March 23, 2011 at 8:07 am
I've just opened up a new connect issue with the details of the SQLAgent.Out.
EDIT: OS is Vista Business 32 bit.
Here's what I've posted:
"2011-03-18 13:34:41 - ! [298] SQLServer Error: 65535,...
March 23, 2011 at 7:56 am
Gah. This is seriously annoying. Neither Repair nor an uninstall / reinstall fixed the issue.
Any more thoughts?
March 23, 2011 at 7:38 am
Kokila, thanks for the advice, but as stated above, the service account is running under full Sysadmin permissions (which would be a complete no-no if I were running this on...
March 23, 2011 at 5:25 am
Viewing 15 posts - 6,226 through 6,240 (of 9,722 total)