tks for your answer. If there are some users with experience on peoplesoft, i will appreciate. Another small question. Doing transactionnal...
Hi, i'm trying to setup transactional replication fro a peoplesoft database running on sql server 2000. I would like to know if some of you already...
tks , i found how to do it : EXEC sp_reinitsubscription @subscriber = 'servername', @destination_db = 'dbname', @publication =...
hi, i set up transactional replication on sql server 2000. It works fine for example for a table. Now my destination db is refreshed everynight, and...
i want to achieve getting the data faster because putting the 2 datafiles on separate disks + also easier to manipulate backup file. I achieved to...
i created a second datafile in the same group, then executed dbbc shrinkfile (datafile1,70000) , but at the end i still have : 1st datafile = 140 gb...
just to make things more clear, i don't want to split the filegroup but the datafile of 140gb to 2* 70 (i with autoextend). Sorry for confusion.
i have only 1 filegroup with 1 datafile in it. Is it not possible to do it whithout creating a second filegroup ? tks for your answer
hello, my sqlserver2000 db has only one file group with 1 mdf of 140 gb. To make things easier (like backup-restore), i would like to split this...
Hi, i have a sql2000 db backup wich is about 135 gb into 1 file . I was restoring everyday this to one other server using this : RESTORE DATABASE...
Separate names with a comma.
