Viewing 15 posts - 25,291 through 25,305 (of 39,957 total)
Look also at RESTORE FILELISTONLY
February 17, 2009 at 7:28 am
Doh! Good catch and glad it's working.
February 17, 2009 at 6:58 am
The thing you could have done is set a very low fill factor and there would be lots of free space on pages, but as you changed data or added...
February 16, 2009 at 10:09 pm
There are also numerous scripts here on this site for backups that you can go through, see how they work, experiment, etc.
February 16, 2009 at 10:06 pm
You don't need to create the blank database, just do the restore.
The command looks OK, what I might suggest is that you run the SQL you need, get that...
February 16, 2009 at 10:04 pm
w3schools is a good place. SQL In A Nutshell is a good book, or really any basic SQL book will help you get started.
February 16, 2009 at 10:02 pm
It's not your account that needs access to the share, it's the SQL service account.
February 16, 2009 at 9:59 pm
Add more memory?
You can't tune dbcc. It has to run through all rows in all tables and that will eat up memory to complete.
February 16, 2009 at 9:57 pm
I'd like to be with you, but I'd also hate to see a big crash. Don't forget the guys with 6 or 7 zeros in their pockets don't suffer. It's...
February 16, 2009 at 9:55 pm
That's not a bad idea. Maybe we can go with more per page.
February 16, 2009 at 9:49 pm
VFP isn't heavily used, but when it is, it's been fairly popular. I'm not sure it's worth learning, but if you know it, there are probably positions out there for...
February 16, 2009 at 9:47 pm
I'm not sure what you mean with 64 columns. Are you saying a column for each 15 minute segment of a day?
If you're looping in ASP, why not track the...
February 16, 2009 at 4:02 pm
I'll give Oracle one thing. they seem to have found a way to convince management to pay more for DBAs on average!
February 16, 2009 at 10:29 am
Viewing 15 posts - 25,291 through 25,305 (of 39,957 total)