Viewing 15 posts - 9,196 through 9,210 (of 9,720 total)
Can you backup while the database is online? If so, how?
Believe it or not, people actually ask that question (though I've never heard it in an interview).
December 13, 2007 at 3:45 am
Well this just stinks. Now I have an extra hour that I have to fill with actual work related things... @=Pbt.
What to do... what to do. I know!...
December 12, 2007 at 8:14 am
Rescheduled? I registered for the event and haven't heard anything back about it being rescheduled. Are they not letting the pre-reg attendees know?
December 12, 2007 at 8:01 am
You can also set logging in the job step where the package is run. Send it to a text file and see what it says.
I'm wondering if the job...
December 12, 2007 at 6:16 am
Where can backup files be saved? What native tools does SQL Server provide for creating backups? How would you access those tools? How would you retrieve the...
December 12, 2007 at 6:14 am
Wow. I am so learning a lot from this thread. I thought I knew details about our SAN. Until I looked at the chart and realized the...
December 12, 2007 at 6:07 am
There is a time limit, but if you know your way around, this isn't an issue.
The questions aren't terribly complicated. You don't have to do 50 things before the...
December 10, 2007 at 10:45 am
There are a couple of ways you can do it.
A) Write a script task (C# .Net or VB .Net) on SSIS and run that job on a scheduled...
December 10, 2007 at 8:41 am
The PBT for exam 431 is totally SSMS based. Essentially, you need to open up Management Studio, going through the Object Explorer bit by bit and figure out how...
December 10, 2007 at 8:37 am
You're welcome.
Let us know if you have any other questions.
December 10, 2007 at 7:07 am
You can pretty much start anywhere. Here's a link to all the SQL Server certs: http://www.microsoft.com/learning/mcp/mcitp/default.mspx
Only three of the certs on that page are relevant to SQL Server....
December 10, 2007 at 4:14 am
You should at least know the syntax to the basic commands and some of the newer stuff. There are multiple choice questions which ask you about syntax and what...
December 10, 2007 at 4:05 am
Odd. In so far as I know, the install of Visual Studio does not automatically install SQL Express. It certainly didn't on mine.
Anyone else see this behavior?
December 7, 2007 at 7:19 am
When SQL 2k5 installs, it goes through a list to check components. Did you see any errors or warnings from that part of the install?
December 7, 2007 at 4:26 am
Viewing 15 posts - 9,196 through 9,210 (of 9,720 total)