Please make note that when you are restoring a distribution database use the "WITH KEEP_REPLICATION" option for it to appear under the system database folder. If you dont use this...

2010-06-24 09:58:57.56 spid449

Memory Manager

VM Reserved = 1523184 KB

...

Hi,

Does this generate any kind of memory dump after this. Check out for any errors like

FAILED TO RESERVE VIRTUAL BYTES *******

Regards,

Mani

Hi,

I would actually go for Upgrade advisor first

And based on that i would go for DTS migrations using SSIS if there are no issues else re designing this in SSIS...

Hi,

Open the backup job and see if the backup folder is on your loacal machine or onto some network shared folder.

If its on the network then see if you can...

Hi Vishal,

Not a problem, will try reproducing this error and see if i can come up with something

Thanks,

Mani

Hi,

You can create a dummy DB and o a select * into table_name from TABLE_NAME

Once the data has been moved, you can then take a backup of the dummy DB...

Hello,

Can you try running

telnet from a remote machine .

This will tell you if your server is able to coomunicate with other systems on this port (1433)

There should...

Hi,

Is there a way to do this without implementing Table partitioning ?

I am not sure how a table data is stored in multiple file groups without table partitioning

Are you sure...

HI Vishal,

What is the backup size ?

Can you share the backup file...

Thanks,

Mani

Hi,

Yes the secondary server will be online and you can use that as on OLAP server which can be used for reporting purpose. The changes from primary to Secondary are...

Hi,

There are quite a lot of errors that i see here

First make sure that the browser and analysis services are running for the server mentioned in the Error message

If the...

HI Gansh,

When you shrink the Log file, the Log file size is reduced to its initial size or size till which it holds the data currently which ever is more....

Hi,

Can you add job step before you run DBCC shrinkfile to dump the LOG_REUSE_WAIT_DESC for the specific DB's to a table or to a text file.

This will help us...

Hello,

Does this show up all users spread across several domains belonging to this grouop.

Example: I have a group domain1\abc which consists of users belonging to several domains like doman1-7

but it...