Viewing 15 posts - 31 through 45 (of 136 total)
http://www.dbaonthego.com/2013/12/powershell-backups-and-post-frequency.html
this is what I have running on my express box. It also deletes older backups for me after a certain amount of time. It should be easy to copy and...
January 2, 2014 at 3:18 pm
Someone help me out here.
If you set it to run every 3 months, it will run every 3 months from the date of the start time.
can you do a...
January 2, 2014 at 1:27 pm
Do you have access to the DC? Verify that the account exists, check what permissions it has. Hopefully something like a service accounts group or so. check the security of...
January 2, 2014 at 1:16 pm
I would just right click the job, go to schedules, select the schedule, and hit edit.
See if the schedule type is listed as recurring, see if the Enabled box is...
January 2, 2014 at 10:19 am
I'll add that the only page splits I'm familiar with is related to fragmentation where the record cannot fit on that page and needs a new one next to it.
as...
January 2, 2014 at 10:16 am
I have a sql server (2012) running on MSServer2008. I created a new SSISW package (took me forever...newb) that references a network share drive. The package works fine running under...
January 2, 2014 at 10:09 am
Double check that your job has a schedule attached to it. Make sure you didn't just move the database and forget to move the job, or moved the job and...
January 2, 2014 at 10:01 am
Please let us know, I'm rather curious. Also, I would restore a copy of your backups to verify they're good and shut down SQL by hand prior to the...
January 2, 2014 at 9:54 am
I have not done this. If it's a virtual, I'd take a backup prior to doing this upgrade... In theory it would work. It's not something I'd do with my...
January 2, 2014 at 9:15 am
I have to agree with Jeff. If you do not have permissions to restart the agent, have your SA do it. If you need those permissions, put in the request...
January 2, 2014 at 9:10 am
Something like the code below? This is from Glenn Berry's site.
SELECT DB_NAME([database_id])AS [Database Name],
[file_id], name, physical_name, type_desc, state_desc,
...
December 17, 2013 at 10:01 pm
Your answers are here. ^.^
December 17, 2013 at 9:54 pm
If you're an admin on the box, you can get in anyways and fix any mistakes you have.
December 17, 2013 at 9:52 pm
I'd like to take the time and say two things.
1) Thank you for coming here and asking DBA's in the field for their opinions.
2) Thank you to the community...
December 17, 2013 at 9:36 pm
Viewing 15 posts - 31 through 45 (of 136 total)