Viewing 15 posts - 751 through 765 (of 1,319 total)
http://www.sqlservercentral.com/Forums/Topic668871-338-2.aspx#bm669990
GSquared (3/6/2009)
I'm surprised, with your credentials, that you don't know that. Or is writing and performance-tuning SQL not your strong point?
Good one G. I don't like to...
March 6, 2009 at 11:58 am
ravikanth (3/5/2009)
check the backup file again.If it has .BKP extension then it can only be restored with Litespeed.
While .bkp is a "backup" file extension, it doesn't necessarily mean it's Litespeed....
March 5, 2009 at 11:54 am
You can create the database on the dev environment and export all the tables but that one on a nighty basis. Be sure your transformation deletes data on the destination...
March 5, 2009 at 8:26 am
kamrul3d (3/5/2009)
i have around 5000 backup file(full database backup) for the last 2 years.No i wants to create a data warehouse(simple) for my database.
my initial tables are
1....
March 5, 2009 at 7:59 am
Simon Liddle (3/5/2009)
a new installation of SQL 7
New??
March 5, 2009 at 7:45 am
Looks to me like about 6000 restores. SQL 2000 does not have object level restores. I believe one or two of the third party tools supports object level restores but...
March 5, 2009 at 7:35 am
Is the database in question on a separate physical disk(s) than the others? Have you checked event logs on the server to see if anything is going on hardware-wise?
March 5, 2009 at 6:10 am
binu.m a (3/4/2009)
HiYes.The recovery issue is only for one db.all other are fine.
Yeah, i understand that. CheckDB runs for one database (or potentially all, depending on your script). Anything in...
March 4, 2009 at 3:12 pm
Do you ever run DBCC CheckDB against the production database causing issues for you? If not, it may be a good idea to check the overall health of the database...
March 4, 2009 at 3:01 pm
Just to add another point to my score - Something tells me we haven't heard the last of Mangal........
March 4, 2009 at 9:24 am
Lynn Pettis (3/4/2009)
And, am I still Saint?
Lynn, always! And then some.
As far as the link, it was available about 15 minutes ago, as I posted a reply. Perhaps Steve disabled/deleted...
March 4, 2009 at 7:10 am
Scott Arendt (3/4/2009)
Anyone else picking up on someone who has posted a lot in the last 24 hours, perhaps just to increase visibility?
I thought the same thing but didn't want...
March 4, 2009 at 7:00 am
Just tossing in my two cents. I know I will post various links quite a bit as well as code snippets where I can. I doubt you're referencing me but...
March 4, 2009 at 6:57 am
Noz (3/2/2009)
We are provided with single .bak files which contain many backups with in it on an ad-hoc basis.
Using one file is not a good thing becuase if that file...
March 3, 2009 at 9:19 am
Viewing 15 posts - 751 through 765 (of 1,319 total)