Viewing 15 posts - 35,686 through 35,700 (of 39,955 total)
I think you'd have to do fulls periodically. At least to keep recovery.
If you do the file backups, then you can probably restore these, ignoring the logs, but it would...
January 2, 2004 at 1:10 pm
Tend to agree, don't like to see threads closed. If the suggestion worked, let us know, but I like to have others be able to continue the thread if need...
January 2, 2004 at 11:02 am
Interesting question. I assume that the Verify backup does just that. Personally we take a slightly different tact.
Each day the backup file is named with the time it starts are...
January 2, 2004 at 11:00 am
I'd use a central procedure that takes the parameters and then calls one of 10 or so subprocedures that performs the search. Seems like a pain, but you set it...
January 2, 2004 at 10:41 am
Not entirely sure, but I'd say 3rd party app as well.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
January 2, 2004 at 10:36 am
I believe it's a byte issue, 256 possible values, -1 for no indexes (0), -1 for clustered (1), maybe a few system items, 255 might be locked out.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best...
January 2, 2004 at 10:35 am
It can help, each file uses a different thread, so this can be benficial. More physical drives can help as well.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
January 2, 2004 at 10:33 am
I ran this from one session:
CREATE TABLE [dbo].[tbltest] (
[Pkey] [int] IDENTITY (1, 1) NOT NULL ,
[fname] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[lname] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]...
January 2, 2004 at 10:22 am
Wouldn't recommend it:http://www.sqlservercentral.com/columnists/sjones/autoclosefordatabases.asp
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
January 2, 2004 at 9:57 am
Tend to agree with the above recommendation. Backup and restore works fine for me as a one time shot, but for continual movement of changes, I like to have a...
January 2, 2004 at 9:55 am
The owner of the view must be the same as the owner of the table and you must grant update permissions on the view.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com...
December 31, 2003 at 10:39 am
I'm not sure there is a good way to do this. My guess is that only your documentation would cover this.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 31, 2003 at 10:38 am
I think it does, but if you are in read only, the difference between your last full and last full + logs is nothing.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com...
December 31, 2003 at 10:35 am
I would dump more frequently as mentioned above.
If you need to shrink it, http://www.sqlservercentral.com/scripts/contributions/26.asp
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 31, 2003 at 10:33 am
Wow, I would have thought this would work. I'll have to experiment with it. Not that BOL seems to be a big deal, updates are few and far between. And...
December 31, 2003 at 10:30 am
Viewing 15 posts - 35,686 through 35,700 (of 39,955 total)