Viewing 15 posts - 31 through 45 (of 100 total)
Spectra,
Are you attempting to connect to the database via an application? If so then connecting using the sa password is very bad practice due to the sa account having full...
September 28, 2006 at 3:10 am
Rama,
Exactly which tables appear to be missing in the restored databases do they all start with the letters sys? Are the Linux applications working as expected?
To get a really good...
September 28, 2006 at 2:56 am
Andrew,
I think you're after the BULK INSERT T-SQL command, checkout BOL 'bulk insert' under 'Transact-SQL Reference. You can then use the ROWS_PER_BATCH or BATCHSIZE arguments.
NOTE: Be sure to size your...
August 2, 2006 at 8:28 am
Michael,
Size and sizing databases can be confusing for some people (it's also a bit of a black art in DBA'ing), it may be worth changing this to 'Approx number of...
August 2, 2006 at 7:50 am
M,
Carolyns right, you really need to employ some decent database design to this, i.e. Nomalizing the design, i.e. splitting the data up into manageable tables and reducing duplication.
A good start...
August 2, 2006 at 7:42 am
SQLRep,
It should be possible for you to create a push subscription from your SQL Server 2000 server to an Oracle (ODBC) subscriber, this is referred to as Publishing to heterogeneous...
August 2, 2006 at 7:23 am
TK,
I'm assuming you are building the new server on new separate hardware?
Below is the approach I would take (given the information you have provided and lack of knowledge of and SLA's etc.).
1) Upgrade the...
August 2, 2006 at 7:06 am
Dave,
What is your (target) linked server, is that a Windows 2003 server as well? I had this problem some time back and then made the following changes within the 'Security...
March 6, 2006 at 7:45 am
Mark,
This MS article explains a lot of what you are asking, in particular your security questions are discussed in Step #2.
ll
oh yes, sorry about that, got distracted adding it to...
March 6, 2006 at 7:26 am
Stephen,
Have you checked the SQL Errorlog to see if you're getting anything reported in there? May also be worth changing the audit level so that you capture failed logins (if...
March 6, 2006 at 7:15 am
terry,
there is no way to do a restore from the original MDF files.
i assumed you had already tried the standard attach in your first post 'Exec sp_attach_db 'SUSDB', 'e:\wsus\susdb.mdf', 'e:\wsus\susdb_log.ldf''
it...
December 1, 2005 at 10:10 am
glad you got it figured out.
may i ask why you are simply removing the SQL service account from local admins? also are you using a local or domain windows account? ...
December 1, 2005 at 9:29 am
right terry,
first of all, did this database originally have multiple log files? see here: http://support.microsoft.com/kb/q271223/ if it did, there's not a lot we can do.
what process did you originally use...
December 1, 2005 at 8:59 am
terry,
have you changed the physical filenename of the data or log files? can you post the query you are running to try and attach the single file.
thanks,
ll
December 1, 2005 at 7:53 am
lowell has a very good point, move/archive (on another physcial drive or folder) any other log or data files you have related to the original database (including the corrupt log file...
December 1, 2005 at 7:06 am
Viewing 15 posts - 31 through 45 (of 100 total)