Viewing 15 posts - 47,281 through 47,295 (of 49,571 total)
The LSNs wouldn't match. SQL won't do the log restore.
Besides, if there's no full backup ever been taken, you can't do a log backup.
February 27, 2008 at 11:24 pm
You are corrct, just note that only a transaction log backup truncated the inactive portion of a llog. A database backup does not.
February 27, 2008 at 11:23 pm
Ad-hoc queries are also compiled and their plans cached.
The increased time may also be due to SQL populating the data cache. On the first read, data must be read from...
February 27, 2008 at 11:21 pm
Rumour also has it that database snapshots may allow what you want, without the need to restore a database at all.
Re filegroups - You can restore individual filegroups in SQL...
February 27, 2008 at 11:20 pm
That's a very big question. It depends very much on the circumstances - a user, specific time of day, all the time, random times, etc
I'd start with performance monitor,...
February 27, 2008 at 11:20 pm
Manie (2/27/2008)
Howcome it is that I don't know about the event in JHB. How did I miss that one!
You didn't miss much. The MS slides and demos were good,...
February 27, 2008 at 10:59 pm
dakshinamurthy (2/26/2008)
Can i uncheck the check box of auto shrink is it okay to do that.
Absolutely. Uncheck it now. Autoshrink should never be enabled on a production server. See...
February 27, 2008 at 4:07 am
Free food, free drink and free swag. What's not to like?
I'll be at the JHB launch in about 5 hours.
February 27, 2008 at 12:17 am
Check the space available and space on disk for the distribution database.
February 27, 2008 at 12:01 am
It's not a stored proc.
ALTER DATABASE <Database name> SET OFFLINE
February 26, 2008 at 11:59 pm
Plase don't post multiple threads on the same problem. It wastes people's time and fragments replies.
Replies to the following thread please - http://www.sqlservercentral.com/Forums/Topic460688-146-1.aspx
February 26, 2008 at 11:10 pm
It would help if you could give us sample input and desired output. I think I'm still misunderstanding what you have and what you want.
February 26, 2008 at 1:34 pm
And the root problem is that you can't use variables to specify the table name. If you want the update to affect different tables depending on the variable, you'll have...
February 26, 2008 at 1:10 pm
Couple problems here.
You're missing a join between the two tables SYCFStore s, SYCFSYSTEM sy. Means you'll get a cross join if they have data in them.
The from clause should be...
February 26, 2008 at 12:45 pm
Viewing 15 posts - 47,281 through 47,295 (of 49,571 total)