Viewing 15 posts - 2,851 through 2,865 (of 49,571 total)
lmarkum (7/1/2016)
July 1, 2016 at 8:39 am
Providing you are in full recovery model and have an unbroken chain of log backups from before the full backup until now.
July 1, 2016 at 8:07 am
Comment out the EXEC and print out the resultant SQL statement, that way you should be able to see what's wrong with it.
July 1, 2016 at 7:33 am
Welsh Corgi (7/1/2016)
What do I need to do?
Msg 3234, Level 16, State 2, Line 2
Logical file ' PrismData_FG2_0' is not part of database 'PrismDataBillingTest'. Use RESTORE FILELISTONLY to list the...
July 1, 2016 at 6:09 am
Add [ before and ] after the database name when you build up the script.
July 1, 2016 at 6:08 am
Welsh Corgi (7/1/2016)
GilaMonster (7/1/2016)
As John said, add the REPLACE option to your restore statement.See https://msdn.microsoft.com/en-us/library/ms186858.aspx for the options and syntax for a RESTORE
ok, I'm tired could you please help me...
July 1, 2016 at 6:08 am
As John said, add the REPLACE option to your restore statement.
See https://msdn.microsoft.com/en-us/library/ms186858.aspx for the options and syntax for a RESTORE
July 1, 2016 at 4:18 am
No further replies here please. Replies to http://www.sqlservercentral.com/Forums/Topic1798979-3739-1.aspx
July 1, 2016 at 4:16 am
Screen shots of the graph are nearly useless, all the interesting information is in tooltips. Please either attach the deadlock graph file or paste the XML
Also the table definition and...
June 30, 2016 at 11:38 am
Duplicate post. No replies please.
Replies to http://www.sqlservercentral.com/Forums/Topic1798746-2799-1.aspx
June 30, 2016 at 7:31 am
manie (6/30/2016)
GilaMonster (6/30/2016)
But surely you picked the DB Mail problem up in your pre-upgrade testing?
No, I am afraid you have me. I did not test it as I am sure...
June 30, 2016 at 6:24 am
The graph's pretty, but far from adequate for solving deadlocks, I never use it, when I teach deadlocks I show the XML only.
June 30, 2016 at 1:18 am
But surely you picked the DB Mail problem up in your pre-upgrade testing?
June 30, 2016 at 1:17 am
select EndYear, SchoolYear, Active from #UserCalendar
where (active = 1 OR EndYear = 2017)
June 29, 2016 at 4:02 pm
LinksUp (6/29/2016)
Sree Divya (6/29/2016)
thankscan you please share the code
how to delete by batch wise
That is something only you can answer. I have no idea what your table looks like and...
June 29, 2016 at 3:58 pm
Viewing 15 posts - 2,851 through 2,865 (of 49,571 total)