Viewing 15 posts - 11,116 through 11,130 (of 22,219 total)
Piling on to what Gail said, you need to provide a domain account for SQL Server and give it permissions to that folder.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 10, 2012 at 4:36 am
dilipd006 (4/9/2012)
Lowell (4/9/2012)
a person with db_owner permissions has the ability to backup, restore, or even drop their own database, i believe.that's very easy to test.
i had already given the db_owner...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 9, 2012 at 7:52 am
Well, since we're recommending tools, you could check out Red Gate SQL Doc too[/url]. And to get help hooking your database into source control, there's SQL Source Control[/url], also from...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 9, 2012 at 7:31 am
S_Kumar_S (4/9/2012)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 9, 2012 at 4:42 am
Similar in concept, but OPENQUERY is like a pass through query. It puts the work on to the remote server.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 8, 2012 at 8:25 pm
To back that stuff up, you backup MSDB. That's it. That's where that information is stored.
Why would this be hard with different servers? You have backup routines scheduled on all...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 8, 2012 at 6:17 am
From everything I've read, you'll have to do an uninstall and a reinstall with the different edition.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 8, 2012 at 6:13 am
Sounds like you're on the right track, especially with adding them to source control. I'd suggest breaking up the storage in source control so that all the objects that belong...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 8, 2012 at 6:12 am
That's going to bring all of the remote server's data back and then perform filtering on it. Horribly inefficient. Instead, look to OPENQUERY where you can pass some parameters that...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 8, 2012 at 6:10 am
You're running those in the wrong order. However, the fact that it grew your database means that's how much space your database needs in order to run the rebuild operations....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 7, 2012 at 5:26 am
Go to the source, Microsoft: Each release of SQL Server has a "What's New" page in the books online. Go to this location in the Books Online and you can...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 7, 2012 at 5:24 am
winston Smith (4/7/2012)
Perry Whittle (4/7/2012)
Server side traces have much less impact apart the potential for required disk space depending on what you are monitoring
I know, I use server side traces...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 7, 2012 at 5:05 am
Jack Corbett (4/6/2012)
What do you all run to backup your home systems?
I may need to buy a new laptop soon. I use...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 6, 2012 at 9:14 am
If other backups are working on the same devices there may not be anything to check.
At this point, I'd call Microsoft support. I mean, I'm not there and I...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 6, 2012 at 6:33 am
RESTORE VERIFYONLY will fail with a Litespeed backup. That's expected.
Hmmm... When you run the native backup using checksum, you're not getting an error? But if you run restore it fails....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 6, 2012 at 5:38 am
Viewing 15 posts - 11,116 through 11,130 (of 22,219 total)