Viewing 15 posts - 226 through 240 (of 497 total)
I have a job to backup the Transaction Log of a Database.
Have you checked that the job is completing successfully? How often are you running the job and is it...
January 21, 2014 at 9:31 am
Do you know what is causing the growth in the log? If not I would start there. What is the log_reuse_wait_desc say in sys.databases for the database in question?
January 21, 2014 at 9:26 am
So, what is the reason to shrink the log file?
January 21, 2014 at 9:22 am
I will let you the status of my database once it is up.
Has your database finished recovery? If not, what does the estimate (see Jason's post) say? and has...
January 21, 2014 at 9:21 am
Is this the same question that Grant and Gail already answered? Or is this a different one? Also, what is the reason to shrink the Transaction log file? Seems like...
January 21, 2014 at 9:11 am
Kind of difficult to answer without more information, but from the looks of it you would want a Sales table that has a SalesDate column. Now depending on what it...
January 21, 2014 at 8:46 am
As Grant suggested I would run this:DBCC CHECKDB WITH ALL_ERRORMSGS, NO_INFOMSGS;
If you get anything back (other than "Command(s) completed successfully") post the entire message to this post.
January 21, 2014 at 8:35 am
SQL Guy 1 (1/17/2014)
You can play with has_backup_checksums column in msdb..backupset table
That is not the same as "Verify backup when finished". That will show you if you selected "Perform...
January 17, 2014 at 9:06 am
Why do you not want to verify your backups?
I'm not sure he's saying he doesn't actually want to verify his backups - just that that isn't what he's asking here...
January 17, 2014 at 9:02 am
Talib123 (1/17/2014)
January 17, 2014 at 8:51 am
I updated your scripts to get rid of the error on PK and I also added more patients so that you can see the effect on multiple patients.
try this:
CREATE TABLE...
January 17, 2014 at 8:45 am
To help speed up the process can you convert you selects into inserts and also test your scripts (there are some errors) and last please provide the expected output based...
January 17, 2014 at 8:22 am
The only way to verify that your backup is "good" is to restore it. You may want to design a system to restore your databases automatically.
January 17, 2014 at 7:33 am
Welcome to the forum! Please read the article in my signature on how to post question to the forum. Since this is your first time I did it for you...
January 16, 2014 at 7:48 pm
BTW, I'm getting below error. Those were for 2005 server.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.dm_os_sys_memory'.
Your question is posted in the SQL Server 2012 forum so...
January 16, 2014 at 2:19 pm
Viewing 15 posts - 226 through 240 (of 497 total)