Viewing 15 posts - 46 through 60 (of 66 total)
Offhand, I think I would approach it like this:
make sure all databases are in full recovery mode
create a script which will backup all the databases
something like 'select dump ' +...
Carlos
March 28, 2007 at 10:51 am
Yes, you have to name all the columns or it won't work. I usually generate the column name and the commas from querying the syscolumns table such as:
select name +...
Carlos
March 28, 2007 at 10:41 am
Would the top function help? as in select top (1).....
Carlos
March 28, 2007 at 10:17 am
March 28, 2007 at 10:09 am
I believe that there's a particular OS setting that must be set on the server so that you can do distributed transactions. Sorry I can't help further.
Carlos
March 28, 2007 at 10:05 am
No, replacing the files using OS commands won't work.
However, you could use sp_detach_db to free up the files and then copy them to a named directory (20070328 for example)
When you...
Carlos
March 28, 2007 at 10:03 am
I just realized that my post was somewhat confusing so I'm including an example:
set identity_insert customers on
insert into customers (customerid, name, address) select customerid, name, address from customers_old
set identity_insert customers...
Carlos
March 28, 2007 at 9:58 am
Try
set identity_insert <yourtable> on
insert into yourtable (columns) select columns from othertable
set identity_insert <yourtable> off
The columns have to be named.
Carlos.
Carlos
March 28, 2007 at 9:55 am
Yes, either of the solutions I propose will accomplish what you want.
Carlos.
Carlos
March 27, 2007 at 2:45 pm
Assuming that the data is in different servers...
As I understand, you have data in one table in one database that is not present in the table that the users are...
Carlos
March 27, 2007 at 2:19 pm
I normally use either linked servers and execute a copy from the remote server to the local for any rows missing (using the primary key) or, I extract the rows...
Carlos
March 27, 2007 at 11:17 am
Matt:
I'm not sure that it would work. I just stopped taking log backups for the database (relying on the backups that the log shipping configuration is doing). I also do...
Carlos
March 27, 2007 at 11:07 am
Matt:
Are you doing standard transaction log backups in addition to the log shipping backups? If so, it's possible that your transaction log backups are interfering with the log shipping backups...
Carlos
March 27, 2007 at 10:29 am
I know that this doesn't help you at this moment, but several years ago, the DBA's where I work made an agreement that all stored procedure would follow a predetermined...
Carlos
March 26, 2007 at 3:36 pm
Don't forget that the login who runs the SQL Server service should be a user who has rights to the network resources that you intend to use
Carlos
March 23, 2007 at 2:41 pm
Viewing 15 posts - 46 through 60 (of 66 total)